I need help understanding the time difference between the to "tim=3D" =
values. I calculated the difference to be (1007496616 - 1007492040) =
4576. But the time clocked in "SQL*Net message from client" is reported =
as 1 centisecond. The "***" line shows that there was a long pause but =
why doesn't the wait event account for the elapsed time? This is the =
first time I observe a discrepancy while walking the trace file. Any =
thoughts would be greatly appreciated.
FETCH =
#4:c=3D0,e=3D0,p=3D0,cr=3D20,cu=3D0,mis=3D0,r=3D1,dep=3D0,og=3D3,tim=3D10=
07492040
*** 2004-05-06 00:13:10.168
WAIT #4: nam=3D'SQL*Net message from client' ela=3D 1 p1=3D1413697536 =
p2=3D1 p3=3D0
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #4 len=3D422 dep=3D0 uid=3D22564 oct=3D3 lid=3D22564 =
tim=3D1007496616 hv=3D557190862 ad=3D'eb942db8'
SELECT
Tony Aponte
Home Shopping Network
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Received on Thu May 06 2004 - 18:18:14 CDT
