Oracle-L: RE: rows values in tkprof

From: Remacle Jean <Jean.Remacle_at_winterthur.be>
Date: Tue, 25 Jun 2002 00:08:20 -0800
Message-ID: <F001.0048646E.20020625000820@fatcity.com>

Ravi,

The rows value comes from the execution plan stored in the trace file at runtime.
The execution plan is only dumped to trace file when the cursor is closed. So, if you take another try with sql*plus for instance and quit sql*plus before closing the trace,
then you will see the rows values printed in your trace. Or if you commit the transaction even if it is a select then you will see the rows count.

That's a matter of fact there is a tkprof option to add the explain plan into the output. All the option does is connect to the database when you issue the tkprof command line and compute a explain plan. I see two quirks here first you do not have a real image of what happened at runtime and second you don't have the rows count.

By the way if your cursor is closed ( you have stats info in your trace file) and you issue a tkprof command with the explain option you will see two execution plan in the output, the stored one and the newly computed one.

Jean Remacle

		-----Original Message-----
		From:	Nalla Ravi [mailto:vvnrk2001_at_yahoo.co.uk]
		Sent:	lundi 24 juin 2002 21:08
		To:	Multiple recipients of list ORACLE-L
		Subject:	rows values in tkprof

		Dear All,

		In my tkprof output rows values under explain plan
		section are not getting printed, is there any
		parameter to be set?

		Thanks,
		Ravi

		__________________________________________________
		Do You Yahoo!?
		Everything you'll ever need on one web page
		from News and Sport to Email and Music Charts
		http://uk.my.yahoo.com
		-- 
		Please see the official ORACLE-L FAQ: http://www.orafaq.com
		-- 
		Author: =?iso-8859-1?q?Nalla=20Ravi?=
		  INET: vvnrk2001_at_yahoo.co.uk

		Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
		San Diego, California        -- Public Internet access /

Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

		the message BODY, include a line containing: UNSUB ORACLE-L
		(or the name of mailing list you want to be removed from).
You may
		also send the HELP command for other information (like

subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Remacle Jean
INET: Jean.Remacle_at_winterthur.be

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jun 25 2002 - 03:08:20 CDT