Re: SQL_Trace on PO7: No CPU time???

On 6 Sep 1996 12:16:56 -0700, stevec_at_zimmer.CSUFresno.EDU (Steve Cosner) wrote:

>
>Hello all,
>
>I have tried getting SQL_Trace to produce Timed_Statistics on my PC
>with Windows3.1, PO7 (7.1.4.1.0), but all I get is elapsed time, and
>no cpu time (all zeros).
>
>I have started the instance with the Timed_Statistics = True option,
>and have done the Set Sql_Trace = True.
>
>And the TKPROF output gives me zeros on CPU time.
>
>Please, help me if you can.
>
>TIA,
>Steve Cosner

Steve,

  Locate your init.ora file and add the following line (it may be called initorcl.ora):

      timed_statistics=true   

 Then shutdown and restart PO7. This is what generates the CPU time statistics for TKPROF.

Jim Joslin Received on Sun Sep 08 1996 - 00:00:00 CEST