How to setting initialization Parameters for Trace File Management

[eagle_lin0729]

How to setting initialization Parameters for Trace File Management?

TIMED_STATISTICS

MAX_DUMP_FILE_SIZE

USER_DUMP_DEST

THANK IN ADVANCE.

[rotem_fo]

Hi,
The USER_DUMP_DEST should be set according to OFA:
$ORACLE_HOME/admin//udump

The MAX_DUMP_FILE_SIZE specifies the maximum size of trace files (excluding the alert file).
MAX_DUMP_FILE_SIZE = {integer [K | M] | UNLIMITED}

TIMED_STATISTICS should be set to TRUE if you want the statistics to be collected and stored in trace files or displayed in the V$SESSTATS and V$SYSSTATS dynamic performance views.

init.ora example:

user_dump_dest = /u01/oracle/admin/orcl/udump
max_dump_file_size = 10240 # limit trace file size to 1 Meg each
timed_statistics = true

Cheers,
rotem_fo.