Tuesday 23 July 2013

ORA-48913

Found this error in one of my production alert logs....has to do with the sizing of my trace files which is also in a way dependent on OS block size. Mine is 512K, I think most UNIX are the same.
ERROR MESSAGE:
Non critical error ORA-48913 caught while writing to trace file "/dboracle/product/dbhome_1/~

SOLUTION:

I increased the "max_dump_file_size" parameter using the SQL syntax below:

SQL> alter system set max_dump_file_size=51200 scope=both;

There is the option of setting max_dump_file_size to UNLIMITED. This means the trace files will grow as much as the OS permits.

This error has nothing to do with the sizing of your alert logs though.

I'll keep monitoring to see if the message shows up once again!

No comments:

Post a Comment