How to Set / Fix / Limit the Oracle 10g 11g Trace File Size

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.
DATA PUMP Reference Guide ….

0 comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...
 

dba topics. Copyright 2011-14 All Rights Reserved | Site Map | Contact | Disclaimer