tkprof help

From: <oracle-l-bounce_at_freelists.org>
Date: Thu, 12 Oct 2006 17:38:25 -0400
Message-ID: <D6424CD4C8A3C044BBC49877ED51C51801DBB11A@ex2003.metratech.com>

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 Received on Thu Oct 12 2006 - 16:38:25 CDT