Friday, December 9, 2011

Controlling trace file size

MAX_DUMP_FILE_SIZE parameter can be used to set the maximum size of a particular trace file 



SQL> show parameter max_dump_file_


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
max_dump_file_size                   string      unlimited


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

System altered.

SQL> show parameter max_dump_file_

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
max_dump_file_size                   string      200M


However, the alert log will will have to be removed. Oracle will recreate it automatically when the situation arises.

No comments:

Post a Comment