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: Jared Still <jkstill_at_gmail.com>
Date: Fri, 26 May 2006 10:25:41 -0700
Message-ID: <bf46380605261025p4f0a5977yc0870133a489f77a@mail.gmail.com>


Possibilities:

A bug. Search MetaLink, and/or open an SR.

Network problem. Get your network folks involved to trace and diagnose if there is a problem.

Jared

On 5/26/06, Yongping Yao <yaoyongping_at_gmail.com> wrote:
>
> 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/
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 26 2006 - 12:25:41 CDT

Original text of this message

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