Re: Arch log files sizes

From: Tim Gorman <>
Date: Wed, 12 Nov 2008 12:18:51 -0700
Message-ID: <>



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   =
email     =
mobile    = +1-303-885-4526
fax       = +1-303-484-3608
Yahoo IM  = tim_evdbt

Prabhu, Krishnaswamy wrote:
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.

Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!
-- Received on Wed Nov 12 2008 - 13:18:51 CST

Original text of this message