RE: 10046 trace and alert log destination full
Date: Wed, 18 Mar 2009 11:18:12 +0200
Btw, if there is some slow batch/program, it is usually cyclic (makes the same thing over and over again). In that case you do not need to trace the whole period, you can trace for an hour or even less and see what's the problem. The same is usually true for single long-running queries.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yechiel Adar Sent: Wednesday, March 18, 2009 10:59 AM Cc: ORACLE-L
Subject: Re: 10046 trace and alert log destination full
Thank you all.
The trace run, did not fill up the destination and not the trace is off.
Now, to find why the application is slow.
Yechiel Adar wrote:
> 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?