Re: row counts are 0 in execution plan part of tkprof

Have a look at the raw trace files.
The rowcounts you get from tkprof are echoing the STAT lines that Oracle has printed. It is just one of those things that

1. 7.3 doesn't always print stat lines
2. 7.3 doesn't always add up the stats correctly anyway.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

jgroff wrote in message <#Mr2lPLLAHA.330_at_cpmsnbbsa09>...


>I'm attempting to do some SQL tuning on 7.3.3 and the execution plans are

>showing 0 row counts for all plans.  Statistics table does have values and

>they seem reasonable.

>

>Anyone have any ideas?

>

>