Re: 10046 trace and alert log destination full

From: Asif Momen <>
Date: Tue, 17 Mar 2009 03:05:36 -0700 (PDT)
Message-ID: <>

Hi Adar,

Instead of filling the 21GB space with the trace info, you could use the "max_dump_file_size" initialization parameter to set the maximum dump file size.

This way you will limit your trace file size. Also, 21 GB of trace data will be too much to digest.

> What happened when this fill up?Is this space allocated to ?
archive location,data fileslog files

Yes, database will continue even it is not able to write to the alert_log.


Asif Momen

  • On Tue, 3/17/09, Yechiel Adar <> wrote: From: Yechiel Adar <> Subject: 10046 trace and alert log destination full To: "ORACLE-L" <> Date: Tuesday, March 17, 2009, 12:45 AM

I plan on activating sys 10046 trace, to find a problem that occurs late at night.
I have about 21 GB free space on the server. What happened when this fill up?
That will stop also the alert log from being written. Does oracle stop in this case or does oracle continue to work and skip the log and trace?


  • Adar Yechiel Rechovot, Israel

Received on Tue Mar 17 2009 - 05:05:36 CDT

Original text of this message