• Welcome
• Projects
• Presentations
• Research

Parameter - 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)