Parameters

TIMED_STATISTICS

This parameter enables the recording of timed statistics. These are included in the output of 10046 trace.

The parameter can be set in the initialisation file e.g.

    timed_statistics = TRUE

This parameter can be set at system level e.g.

    ALTER SYSTEM SET timed_statistics = TRUE

This parameter can be set at session level e.g.

    ALTER SESSION SET timed_statistics = TRUE

When TIMED_STATISTICS is enabled statistics are generated for the following

• PARSE, EXEC and FETCH CPU costs in trace files
• V$WAITSTAT
• V$FILESTAT and V$TEMPSTAT
• V$SYSSTAT and V$SESSTAT timed statistics

Statistics affected by enabling TIMED_STATISTICS include

Wait times are recorded in V$SESSION_EVENT, V$SYSTEM_EVENT and V$SESSION_WAIT irrespective of the setting of TIMED_STATISTICS (9.2.0)