ORA-48913 Writing into trace file failed

Alert :   Non critical error ORA-48913 caught while writing to trace file "/opt/oracle/XXXXX
             /diag/rdbms/nptmp/XXXXX/incident/incdir_288464/XXXXX_ora_23179_i288464.trc"
              Error message: ORA-48913: Writing into trace file failed, file size limit [5242880] reached.

Cause :

                show parameter        max_dump_file_size
                ---------------------------------
                max_dump_file_size        10240

                We are getting this alert in alert.log because when oracle reaches the limit of max 
                dump/trace file size, and its resized to write all content in trace/dump file.
                supported values of this parameter in byes, and special string "UNLIMITED" there is no    
                upper limit of trace file size

Solution : Simply increase the values of max_dump_file_size parameters as per your enviornment  
                 and storage availability.

                SQL> alter system set max_dump_file_size=18240 ;   ( fixed the issued in my case)

                or

                SQL> alter system set max_dump_file_size=UNLIMITED ;
                         ( write dump/trace file as per OS max size limit).


                Hope this article will help you for solving the issue.


=========== Use knowledge to help others not to defect    ============================