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