Wednesday, February 27, 2013

Solution to ORA-48913 caught while writing to trace file

On, encountered the following error in the alert.log:

Non critical error ORA-48913 caught while writing to trace file "/oraotcprd1/app/oracle/diag/rdbms/otcprd1/OTCPRD11/trace/OTCPRD11_ora_14925.trc"
Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached

The reason was Parameter MAX_DUMP_FILE_SIZE  is set too low.


We can increase the setting for the parameter MAX_DUMP_FILE_SIZE or set it to unlimited

MAX_DUMP_FILE_SIZE specifies the maximum size of trace files (excluding the alert file). Change this limit if you are concerned that trace files may use too much space.
  • A numerical value for MAX_DUMP_FILE_SIZE specifies the maximum size in operating system blocks.
  • A number followed by a K or M suffix specifies the file size in kilobytes or megabytes.
  • The special value string UNLIMITED means that there is no upper limit on trace file size. Thus, dump files can be as large as the operating system permits.



  1. This is a good article & good site.Thank you for sharing this article. It is help us following categorize:
    healthcare, e commerce, programming,multi platform, it consulting, retail, manufacturing, CRM, technology means, digital supply chain management, Delivering high-quality service for your business applications,
    Solutions for all Industries,
    Getting your applications talking is the key to better business processes,
    Rapid web services solutions for real business problems,
    Web-based Corporate Document Management System,
    Outsourcing Solution,
    Financial and Operations Business Intelligence Solution,

    Our address:
    2002 Timberloch Place, Suite 200
    The Woodlands, TX 77380


  2. Check this for similar issues:

  3. Hi, I tried that recommended adding parameters in the sqlnet.ora, changed max_dump_file_size .

    connect sys as sysdba
    Oracle Version:
    OS: Windows
    Location of files: ..\ORACLE\diag\clients\user_SYSTEM\host_xxxxxxx_xx\the trace

    File ora_xxxx_xxx.trc is locked, it weighs more than 10 GB.

    Who holds, how to unlock and delete?