Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to read trace file

RE: How to read trace file

From: Robertson Lee - lerobe <lerobe_at_acxiom.co.uk>
Date: Mon, 12 Nov 2001 01:44:44 -0800
Message-ID: <F001.003C205A.20011112010017@fatcity.com>

That
needs to be tkprof'd unless I am much mistaken. <SPAN
class=312170209-12112001> 
<SPAN
class=312170209-12112001> 

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Daiminger, Helmut   [mailto:Helmut.Daiminger_at_KirchGruppe.de]Sent: 12 November 2001   08:25To: Multiple recipients of list ORACLE-LSubject:   How to read trace file
  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 <FONT
  size=2>EXEC 

#1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1737274602 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=4,mis=0,r=24,dep=0,og=4,tim=1737274603 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274603 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274604 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274605 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274605 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274606 <FONT
size=2>FETCH
#1:c=0,e=1,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274607 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274607 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274608 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274608 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274610 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274615 <FONT
size=2>FETCH
#1:c=1,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274620 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274628 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274629 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274630 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274630 <FONT
size=2>FETCH
#1:c=1,e=0,p=0,cr=2,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274631 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274632 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274632 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274633 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274634 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274635 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274635 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274636 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274637 <FONT
size=2>FETCH
#1:c=0,e=1,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274638 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274638 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274639 <FONT
size=2>FETCH
#1:c=0,e=1,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274640 <FONT
size=2>FETCH
#1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=24,dep=0,og=4,tim=1737274640 <FONT
size=2>FETCH

#1:c=0,e=0,p=0,cr=3,cu=0,mis=0,r=11,dep=0,og=4,tim=1737274641 <FONT
  size=2>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. Received on Mon Nov 12 2001 - 03:44:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US