Oracle-L: tkprof plan missing rows

From: Baker, Barbara <bbaker_at_denvernewspaperagency.com>
Date: Wed, 13 Mar 2002 00:13:23 -0800
Message-ID: <F001.0042689E.20020313001323@fatcity.com>

Oracle 7.3.4, OpenVMS 7.1

My tkprof report is missing the row count in the execution plan. Does anyone know why what I might be missing? If I autotrace the same query in the same database, I do get cardinality. The tables have been analyzed.

If I tkprof another database using the same version and OS, that tkprof DOES have row counts.
I believe I'm just missing a parameter somewhere, but I don't know where.

Thanks for any ideas.
Barb

$ tkprof DRAX02_AMPROD_FG_SRV_041.TRC;1 sel.tkp explain=user/pwd sys=no

Rows Execution Plan

-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   TABLE ACCESS   GOAL: ANALYZED (BY ROWID) OF 'WO'
      0    INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'PK_WO' (UNIQUE)



****************************************************************************

here's a tkprof from a different database:

Rows Execution Plan

-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE

1440212 SORT (GROUP BY)
2785044 HASH JOIN

3109095     TABLE ACCESS   GOAL: ANALYZED (BY ROWID) OF
                'WORK_ORDER_DETAILS'
3762491      INDEX   GOAL: ANALYZED (RANGE SCAN) OF
                 'WORK_ORDER_DETAILS_IDX3' (NON-UNIQUE)
5727880     TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'SLS_OF_REC'



****************************************************************************

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: bbaker_at_denvernewspaperagency.com 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).

Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification. ------_=_NextPart_001_01C1C75E.2B46D480-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: bbaker_at_denvernewspaperagency.com 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).

application/ms-tnef attachment: winmail.dat

Received on Wed Mar 13 2002 - 02:13:23 CST