RE: tkprof help

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
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

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 12 2006 - 16:47:05 CDT