How to read trace file

From: Daiminger, Helmut <Helmut.Daiminger_at_KirchGruppe.de>
Date: Mon, 12 Nov 2001 00:52:24 -0800
Message-ID: <F001.003C201A.20011112002517@fatcity.com>

Hi!

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 t0

END 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 Received on Mon Nov 12 2001 - 02:52:24 CST