Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: dblink hangs

Re: dblink hangs

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Fri, 26 May 2006 18:02:33 UT
Message-Id: <1148666553.30430.262412228@webmail.messagingengine.com>

Since Create table works , i suggest you use the COPY command with INSERT; Use reasonable arraysize ; Since COPY commits every arraysize rows it might offer some insight into the nature of problem.

HTH GovindanK

On Fri, 26 May 2006 15:51:47 +0800, "Yongping Yao" <yaoyongping_at_gmail.com> said:

  Hi all,
  We have a [1]10.2.0.1 SvrA and 9204 SvrB   Now on SvrA we run : Create table test as select * from test1_at_SvrB;   with 100K rows records, it completes in several minutes.   But if we use INSERT INTO test select * from test1_at_SvrB;   it will hang for days.
  I selected v$session_wait. In SvrA it's waiting for "SQL*NET more data from dblink". In SvrB, it's waiting for "SQL*NET more message from client". The network is OK. No package loss and the latency is about 0.1ms.   We met this situation before between two 9204 too.   Can someone explain it? Thx in advance   --
  Yao Yongping
  Learning Oracle, UNIX/Linux...
  Love Reading, Classical Music, Philosophy, Economics etc.   Blog: [2]http://spaces.msn.com/members/yaoyp/

References

  1. http://10.2.0.1/
  2. http://spaces.msn.com/members/yaoyp/
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 26 2006 - 13:02:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US