...more data from dblink...

  • From: "Barr, Stephen" <Stephen.Barr@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 5 Apr 2005 16:26:09 +0100

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.
-----------------------------------------------------------------------



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

Other related posts: