Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using SQL Developer to view trace files

chuckersApr 2 2009 — edited Apr 9 2009
I got the following instructions from here

http://download.oracle.com/docs/cd/E12151_01/doc.150/e12152/intro.htm#i1013610

which state
1.6.3 Displaying SQL Trace (.trc) Files
  If you have any SQL Trace (.trc) output files, you can display 
  them in SQL Developer as an alternative to using the TKPROF 
  program to format the contents of the trace file. To open a 
  *.trc file in SQL Developer and see an attractive, effective 
  display of the information, click File, then Open, and specify 
  the file; or drag the file's name or icon into the SQL Developer 
  window.

  You can then examine the information in the List View, Statistics 
  View, and History panes, with each pane including options for 
  filtering and controlling the display.
I can load a *.trc file into the Worksheet Editor, and I can see the benefit of the formatting it provides. But, for the life of me, I can't find the List View, Statistics View, or History pane, to see the TKPROF-like output that the documentation suggests is possible. Has anyone figured this one out before? Or, does SQL Developer only provide formatting to the *.trc file itself, and that's it, and I'm misreading the documentation?

Thanks,
Chuck
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2009
Added on Apr 2 2009
3 comments
9,453 views