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.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment