Re: help:tkprof exlpain returns 0 rows

On Wed, 04 Aug 2004 12:21:51 GMT, "JoeBayer" <joebayerii_at_hotmail.com> wrote:

>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.
>

when you use the explain option, you get a new plan ignoring the data in the trace file.

--
Sybrand Bakker, Senior Oracle DBA