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
Harvinder,
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
--
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
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Sent: Thursday, October 12, 2006 5:38 PM
To: oracle-l
Subject: tkprof help
Hi,
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?
Thanks
--Harvinder
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
