RE: 10046 trace and alert log destination full
- From: Yavor Ivanov <Yavor_Ivanov@xxxxxxxx>
- To: "adar666@xxxxxxxxxxxx" <adar666@xxxxxxxxxxxx>
- 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.
Regards,
Yavor Ivanov
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
Adar Yechiel
Rechovot, Israel
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?
>
> TIA
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: