Re: 10046 trace and alert log destination full
- From: Asif Momen <asif_oracle@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>, adar666@xxxxxxxxxxxx
- Date: Tue, 17 Mar 2009 03:05:36 -0700 (PDT)
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.
Regards
Asif Momen
http://momendba.blogspot.com
--- On Tue, 3/17/09, Yechiel Adar <adar666@xxxxxxxxxxxx> wrote:
From: Yechiel Adar <adar666@xxxxxxxxxxxx>
Subject: 10046 trace and alert log destination full
To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
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?
TIA
-- Adar Yechiel
Rechovot, Israel
--
//www.freelists.org/webpage/oracle-l
Other related posts:
