...more data from dblink...

From: Barr, Stephen <Stephen.Barr_at_bskyb.com>
Date: Tue, 5 Apr 2005 16:26:09 +0100
Message-ID: <4127F81F6CAFC245A18BC49054EFB0638B174E@ssslexchusr6.sssl.bskyb.com>

Solaris 8 64bit
Oracle 10.1.0.2.0 64 bit  

Does the following extract from a trace file really mean that oracle is only fetching between 1 and 6 bytes per call?  

WAIT #2: nam='SQL*Net more data from dblink' ela= 44 p1=1413697536 p2=2 p3=0

WAIT #2: nam='SQL*Net more data from dblink' ela= 47 p1=1413697536 p2=6 p3=0

WAIT #2: nam='SQL*Net more data from dblink' ela= 51 p1=1413697536 p2=3 p3=0

WAIT #2: nam='SQL*Net more data from dblink' ela= 54 p1=1413697536 p2=1 p3=0

WAIT #2: nam='SQL*Net more data from dblink' ela= 45 p1=1413697536 p2=4 p3=0

WAIT #2: nam='SQL*Net more data from dblink' ela= 39 p1=1413697536 p2=1 p3=0

WAIT #2: nam='SQL*Net more data from dblink' ela= 52 p1=1413697536 p2=5 p3=0

WAIT #2: nam='SQL*Net more data from dblink' ela= 51 p1=1413697536 p2=1 p3=0

WAIT #2: nam='SQL*Net more data from dblink' ela= 52 p1=1413697536 p2=6 p3=0

WAIT #2: nam='SQL*Net more data from dblink' ela= 48 p1=1413697536 p2=2 p3=0  

Thanks,  

Steve.

---

Information in this email may be privileged, confidential and is intended exclusively for the addressee. The views expressed may not be official policy, but the personal views of the originator. If you have received it in error, please notify the sender by return e-mail and delete it from your system. You should not reproduce, distribute, store, retransmit, use or disclose its contents to anyone.  

Please note we reserve the right to monitor all e-mail communication through our internal and external networks.

---

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

Received on Tue Apr 05 2005 - 11:30:20 CDT