Home » RDBMS Server » Performance Tuning » Interpretation Trace file
Interpretation Trace file [message #65660] Wed, 24 November 2004 20:26 Go to next message
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

 

 

 

 

 

 
Re: Interpretation Trace file [message #65665 is a reply to message #65660] Thu, 25 November 2004 20:27 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Use tkprof to generate a readable report from your trace.

hth
Previous Topic: PL/SQL commit
Next Topic: Pl Help To Tune Full table Scans.
Goto Forum:
  


Current Time: Thu Mar 28 15:17:42 CDT 2024