Oracle 11g Recommendations are below.
SQL> show parameter max_dump_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_dump_file_size string 20000
SQL> alter system set max_dump_file_size=UNLIMITED scope=both;
System altered.
SQL> show parameter max_dump_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_dump_file_size string UNLIMITED
SQL> show parameter max_dump_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_dump_file_size string 20000
SQL> alter system set max_dump_file_size=UNLIMITED scope=both;
System altered.
SQL> show parameter max_dump_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_dump_file_size string UNLIMITED
Thank you! Helpful guide
ReplyDelete