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;