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 Noida viewed 'Data Pump EXPDP IMPDP EXCLUDE and INCLUDE Options ' 3 hrs 4 mins ago

A visitor from Denizli viewed 'RMAN-06059 ORA-19625 backup archivelog all delete ' 6 hrs 39 mins ago

A visitor from Wakayama viewed 'How to Enable or Disable the Supplemental Logging ' 7 hrs 23 mins ago

A visitor from Perm viewed 'How to Increase, Decrease or Resize FRA(Flash Reco' 9 hrs 38 mins ago

A visitor from St petersburg viewed 'Data Pump Impdp TRANSFORM option SEGMENT_ATTRIBUTE' 9 hrs 43 mins ago

Real-time | Get Script | More Info