RE: tkprof help

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <Harvinder.Singh@xxxxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 12 Oct 2006 17:47:05 -0400


Do you actually see any internal SQL statements in the report?  I think
that 'sys=no' will filter out the internal SQLs, but they still get
counted in the summary in the end.  Those statements still are in the
trace file you fed to TkProf so they are counted in the summary.  The
'sys=no' simply filters them from the report. 

Hope that helps,


Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

There is nothing so useless as doing efficiently that which shouldn't be
done at all.  -Peter F. Drucker, 1909-2005

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
Sent: Thursday, October 12, 2006 5:38 PM
To: oracle-l
Subject: tkprof help


I am using tkprof with the following options:
waits=yes sys=no explain=user1/user1

Still I can see lot of internal sql's as shown by last lines of tkprof
output file:
7390  user  SQL statements in trace file
88912  internal SQL statements in trace file.
3347  SQL statements in trace file.

Which option do I need to use if I just want to see information about
the user sql statement in the output file?




Other related posts: