Thursday, August 14, 2014

Non critical error ORA-48913 caught while writing to trace file "/oracle/saptrace/diag/rdbms/XXX/trace/XXX_lgwr_36503556.trc" Error message: ORA-48913: Writing into trace file failed, file size limit [10240000] reached End of report

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

1 comment:

Thursday, August 14, 2014

Non critical error ORA-48913 caught while writing to trace file "/oracle/saptrace/diag/rdbms/XXX/trace/XXX_lgwr_36503556.trc" Error message: ORA-48913: Writing into trace file failed, file size limit [10240000] reached End of report

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

1 comment:

My Blog List