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:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
