Re: Arch log files sizes
From: Tim Gorman <tim_at_evdbt.com>
Date: Wed, 12 Nov 2008 12:18:51 -0700
Message-ID: <491B2C1B.5020205@evdbt.com>
The size of an archived redo log file won't be any larger than your online redo log files, but they can be smaller for lots of reasons. One cause is issuing the command ALTER SYSTEM SWITCH LOGFILE at random times -- that'll generate a bunch of smaller archived redo log files. Instance shutdown will essentially have the same effect. If you're running Data Guard, some parameter settings (i.e. archive_lag_target > 0) can cause switches to occur before the online log files "fill".
Hope this helps....
Prabhu, Krishnaswamy wrote:
Date: Wed, 12 Nov 2008 12:18:51 -0700
Message-ID: <491B2C1B.5020205@evdbt.com>
Prabhu,
The size of an archived redo log file won't be any larger than your online redo log files, but they can be smaller for lots of reasons. One cause is issuing the command ALTER SYSTEM SWITCH LOGFILE at random times -- that'll generate a bunch of smaller archived redo log files. Instance shutdown will essentially have the same effect. If you're running Data Guard, some parameter settings (i.e. archive_lag_target > 0) can cause switches to occur before the online log files "fill".
Hope this helps....
Tim Gorman consultant - Evergreen Database Technologies, Inc. P.O. Box 630791, Highlands Ranch CO 80163-0791 website = http://www.EvDBT.com/ email = Tim@EvDBT.com mobile = +1-303-885-4526 fax = +1-303-484-3608 Yahoo IM = tim_evdbt
Prabhu, Krishnaswamy wrote:
List,-- http://www.freelists.org/webpage/oracle-l Received on Wed Nov 12 2008 - 13:18:51 CST
We are running 10204 instances, recently the arch log destination got filled up 100% and we noticed few arch logs files sizes are varying, the sizes are twice larger than the average file size, archive_lag_target is set to 0. Can anyone please throw more insight on this.
Thanks
Prabhu
Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!