RE: Difference on ArchiveLog

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Wed, 07 Jan 2004 12:29:32 -0800
Message-ID: <F001.005DC02A.20040107122932@fatcity.com>

Mauricio,

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 [mailto:oraclemavelgo@yahoo.com]
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: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: thomas.mercadante_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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