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.
It is better to ask and appear ignorant, than to remain silent and remain ignorant.
Oracle OCP DBA 9i,
C++, Java developer