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 Zapopan viewed 'Fix DGMGRL Error: ORA-16698: LOG_ARCHIVE_DEST_n pa' 5 mins ago

A visitor from New york viewed 'How to Get Current SCN for Oracle 10g 11g Database' 1 hr 26 mins ago

A visitor from Washington viewed 'How to Enable or Disable the Supplemental Logging ' 3 hrs ago

A visitor from Florida viewed 'How to Get SQLPLUS Query Output to a Shell Script ' 3 hrs 6 mins ago

A visitor from Calgary viewed 'Oracle 11g User Account Status LOCKED(TIMED) with ' 4 hrs 22 mins ago

Real-time | Get Script | More Info