Interpretation Trace file [message #65660] |
Wed, 24 November 2004 20:26 |
Selva
Messages: 15 Registered: June 2001
|
Junior Member |
|
|
Hi,
I am looking into the trace file of Oracle 9i.i am interested only on the response time of a SQL statement.
In that case,should i see only the fetch events (ie 369 microsec in the trace file)or Sum of e values in parse/exec/fetch events( ie 1504+235+369).
For example,this is my trace file
*** 2004-09-28 17:51:06.580
*** SESSION ID:(82.8720) 2004-09-28 17:51:06.427
APPNAME mod='SQL*Plus' mh=3669949024 act='' ah=4029777240
=====================
PARSING IN CURSOR #1 len=25 dep=0 uid=246 oct=3 lid=246 tim=7354213631896 hv=1279374520 ad='2d869190'
select sysdate from dual
END OF STMT
PARSE #1:c=0,e=1504,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=7354213481856
WAIT #1: nam='SQL*Net message to client' ela= 14 p1=675562835 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 274 p1=675562835 p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 1 p1=675562835 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 198 p1=675562835 p2=1 p3=0
WAIT #0: nam='SQL*Net message to client' ela= 1 p1=675562835 p2=1 p3=0
WAIT #0: nam='SQL*Net message from client' ela= 2531 p1=675562835 p2=1 p3=0
BINDS #1:
EXEC #1:c=0,e=235,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=7354213636260
WAIT #1: nam='SQL*Net message to client' ela= 5 p1=675562835 p2=1 p3=0
FETCH #1:c=0,e=369,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=7354213636740
*** 2004-09-28 17:51:21.748
WAIT #1: nam='SQL*Net message from client' ela= 14807498 p1=675562835 p2=1 p3=0
=====================
Thanks in Advance,
Selva
|
|
|
|