-----Original Message-----
From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]
Sent: 12 November 2001 08:25
To: Multiple recipients of list ORACLE-L
Subject: How to read trace fileHi!
A developer handed me a trace file that he has taken from a session. How do I read the output? It looks totally different from the ones that I know (formatted by tkprof).
The Performace Tuning Book from Oracle Press doesn't have anything about that trace output in it as well.
Could anybody please point me in the right direction?
PARSING IN CURSOR #1 len=262 dep=0 uid=46 oct=3 lid=46 tim=1737274602 hv=542987539 ad='8ad3051c'
SELECT t0.access_key_fi, t0.box_name, t0.content_fi, t0.menu_id, t0.internal_name, t0.ordinal, t0.page_key, t0.parent_menu_fi, t0.publish_from, t0.publish_priority, t0.publish_to, t0.published_at, t0.short_description, t0.style_fi, t0.target FROM NM_SIT_MENU t0END OF STMT
PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1737274602
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1737274602
FETCH #1:c=0,e=0,p=0,cr=1,cu=4,mis=0,r=24,dep=0,og=4,tim=1737274603
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274603
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274604
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274605
FETCH #1:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274605
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274606
FETCH #1:c=0,e=1,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274607
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274607
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274608
FETCH #1:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274608
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274610
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274615
FETCH #1:c=1,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274620
FETCH #1:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274628
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274629
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274630
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274630
FETCH #1:c=1,e=0,p=0,cr=2,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274631
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274632
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274632
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274633
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274634
FETCH #1:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274635
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274635
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274636
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274637
FETCH #1:c=0,e=1,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274638
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274638
FETCH #1:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274639
FETCH #1:c=0,e=1,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274640
FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274640
FETCH #1:c=0,e=0,p=0,cr=3,cu=0,mis=0,r=11,dep=0,og=4,tim=1737274641
XCTEND rlbk=0, rd_only=1
STAT #1 id=1 cnt=755 pid=0 pos=0 obj=26567 op='TABLE ACCESS FULL NM_SIT_MENU '
This is 8.1.7 on Sun Solaris.
Thanks,
Helmut
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this communication to the sender and delete the
original message or any copy of it from your computer
system.
