How to Set or Limit Trace File Size in Oracle 11g   Leave a comment

MAX_DUMP_FILE_SIZE defines the size of Trace Files in Orace.

SQL> SHOW PARAMETER MAX_DUMP_FILE_SIZE

NAME TYPE VALUE
———————————— ———– ———–
max_dump_file_size string unlimited

SQL> alter session set max_dump_file_size=’250M’;

Session altered.

SQL> show parameter max_dump_file_size

NAME TYPE VALUE
———————————— ———– ———–
max_dump_file_size string 250M

SQL> alter system set max_dump_file_size=’250M’;

To Revert that to unlimited

SQL> alter system set max_dump_file_size=unlimited;

Posted November 10, 2014 by runfordennis in Uncategorized