How to setting initialization Parameters for Trace File Management?
TIMED_STATISTICS
MAX_DUMP_FILE_SIZE
USER_DUMP_DEST
THANK IN ADVANCE.
How to setting initialization Parameters for Trace File Management?
TIMED_STATISTICS
MAX_DUMP_FILE_SIZE
USER_DUMP_DEST
THANK IN ADVANCE.
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.