Re: dblink hangs

Thank you all.
I tried restart the two database but the problem is not solved. I digged the metalink. There is a bug about hangs during INSERT through dblink, but it's fixed in Oracle 8i :( . I'm now working on the network. It seems that PING is OK but moving data is a little slow.

On 5/27/06, GovindanK <gkatteri_at_fastmail.fm> wrote:
>
> 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 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: http://spaces.msn.com/members/yaoyp/
>
>

-- 
Yao Yongping
Learning Oracle, UNIX/Linux...
Love Reading, Classical Music, Philosophy, Economics etc.
Blog:  http://spaces.msn.com/members/yaoyp/

--
http://www.freelists.org/webpage/oracle-l