help:tkprof exlpain returns 0 rows

Hi, I am using Oracle 9i on Red Hat Linux.

1. I set event "10046, level=8"
2. I run the query, and got about 400 rows back
3. I run "tkprof test.trc output.txt explain=user/pass"
4. The output file is fine except all the rows is 0, which is the most important thing I want to know

Rows Execution Plan

-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   SORT (UNIQUE)
      0    NESTED LOOPS
      0     NESTED LOOPS
      0      NESTED LOOPS
      0       NESTED LOOPS
      0        NESTED LOOPS
      0         INDEX   GOAL: ANALYZED (RANGE SCAN) OF
                  'PK_STREET_INTR_NAMES' (UNIQUE) PARTITION: START=2 STOP=
                    2
      0         TABLE ACCESS   GOAL: ANALYZED (BY LOCAL INDEX ROWID)
                    OF 'STREET_INTERSECTION' PARTITION: START=2 STOP=2
      0          INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF
                   'PK_STREET_INTERSECTION' (UNIQUE) PARTITION: START=2
                     STOP=2
      0        TABLE ACCESS   GOAL: ANALYZED (BY LOCAL INDEX ROWID)
....................

What I did was wrong?

Your help is highly appreciated. Received on Wed Aug 04 2004 - 07:21:51 CDT