Oracle-L: tkprof plan missing rows

From: Baker, Barbara <bbaker_at_denvernewspaperagency.com>
Date: Fri, 08 Mar 2002 08:16:29 -0800
Message-ID: <F001.004235C6.20020308081629@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).

Received on Fri Mar 08 2002 - 10:16:29 CST