Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Difference on ArchiveLog

RE: Difference on ArchiveLog

From: Mercadante, Thomas F <>
Date: Wed, 07 Jan 2004 12:29:32 -0800
Message-ID: <>

Think about it. 
Your redo logs are now larger, and they have to be cleared out by the archiver less often.  So archivelog files are produced less often.  So you have less physical archive log files being produced.
The other data that *used to be* in archivelog files are now in the Redo Log files.  It hasn't gone anyplace - it's just waiting for the Redo Log file to fill up so it can be archived.
The metric that you should be looking at is not how much archive log is being generated - but how often a log file switch is being performed.  I like no less than 20 minutes - that is - an archivelog file is not being created more often that 20 minutes.  This ensures that the database is never waiting for the archiver to complete it's work (thus stopping updates) before it can continue.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Mauricio "Vilez []
Sent: Wednesday, January 07, 2004 3:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Difference on ArchiveLog

Hello Everybody


Some days ago the database I work on had 3 logfiles that sized 100M and the database was generating 4G of archive daily.

I changed the  size to 20M and the database began to generate 2G of archive daily, then I changed to 50M and It began to generate 3G of archive daily.


So I don't understand why this difference occurs.


The database I'm working on is oracle 8i and I'is on Windows NT.


Regards Mauricio Vélez

Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
Please see the official ORACLE-L FAQ:
Author: Mercadante, Thomas F

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Jan 07 2004 - 14:29:32 CST

Original text of this message