RE: 10046 trace and alert log destination full

From: Yavor Ivanov <>
Date: Wed, 18 Mar 2009 11:18:12 +0200
Message-ID: <BD17E2E69E17C64A9684C940EB580E030111B02EF4BC_at_stemodc1.stemo.local>

	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.

Yavor Ivanov

-----Original Message-----
From: [] 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?


Received on Wed Mar 18 2009 - 04:18:12 CDT

Original text of this message