How to Set / Fix / Limit the Oracle 10g 11g Trace File Size

advertisements

_____________________________________________________________________________________________________________________

The size of the trace file in Oracle determined by the parameter is max_dump_file_size. If you set the value of this parameter to UNLIMITED the trace file will occupy the total available size in the file system if it is required. You can limit the value in session or system level by changing the value of the max_dump_file_size.

SQL> show parameter max_dump_file_size

NAME                                 TYPE        VALUE

------------------------------------ ----------- -----------

max_dump_file_size                   string      unlimited

SQL> alter session set max_dump_file_size='200m';

Session altered.

SQL> show parameter max_dump_file_size

NAME                                 TYPE        VALUE

------------------------------------ ----------- -----------

max_dump_file_size                   string      200M

SQL> alter system set max_dump_file_size='200m';

System altered.

Revert the value to the unlimited value.

SQL> alter system set max_dump_file_size=unlimited;

System altered.

_____________________________________________________________________________________________________________________

Live Traffic Feed

A visitor from Victoria viewed 'Data Pump EXPDP IMPDP EXCLUDE and INCLUDE Options ' 8 mins ago

A visitor from Zapopan viewed 'Fix DGMGRL Error: ORA-16698: LOG_ARCHIVE_DEST_n pa' 54 mins ago

A visitor from Guadalajara viewed 'Global Index Vs Local index – Difference, Advantag' 1 hr 30 mins ago

A visitor from Ronkonkoma viewed 'GoldenGate GGSCI Register / Unregister Extract Fai' 1 hr 48 mins ago

A visitor from California viewed 'Data Pump EXPDP : How to EXCLUDE table partition e' 2 hrs 22 mins ago

Real-time | Get Script | More Info