Re: TKPROF and Trace Files

In article <C9u8y3.I1B_at_dcs.ed.ac.uk> pgk_at_dcs.ed.ac.uk writes:

>I have a question to do with the information produced having run a trace file
>through the TKPROF utility.
>
>I have been generating trace files and examining them for a variety of queries
>by using the TKPROF utility as documented in the "Performance Tuning Guide".
>
>In the resultant files, however, the values in the "cpu" and "elap" fields
>never get above zero for any of the "parse", "execute" or "Fetch" steps.
>
>I've tried all kinds of queries from simple joins to multiple joins to tree
>queries on a tree with depth 1,000 yet these two fields are always zero.
>The tree query actually takes a good few minutes to execute but still the
>"cpu" and "elap" fields remain zero.
>
>Can anybody out there explain why these results always remain zero.
>
>Notes:
>
>- The version of Oracle is V6.0.33.1.1.
>- The "cpu" field contains the total CPU times for the "parse", "fetch" and
> "execute" steps
> in hundredths of seconds
>- The "elap" field contains the total elapsed times for each step in hundredths
> of seconds
>
>Thanks
>
>Paul
>

        Hi

        You don't have the init.ora timed_statistics parameter set to true.

  tina C London