Cc: rac_oracledba@msn.com, oracle-l@freelists.org
Message-Id: <5EFEC89B-9F80-434C-9F52-E49C5FF73E8D@bluegecko.net>
From: Jeremiah Wilton <jwilton@bluegecko.net>
To: andrew.kerber@gmail.com
In-Reply-To: <ad3aa4c90907071042g16b78eabiea8f55ce48ea7e1d@mail.gmail.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v935.3)
Subject: Re: archivelog performance issues
Date: Tue, 7 Jul 2009 13:25:26 -0700
References: <4A537289.2090102@lanl.gov>	 <582568.13479.qm@web58704.mail.re1.yahoo.com>	 <6AFC12B9BFCDEA45B7274C534738067F1A9A5716@AAPQMAILBX02V.proque.st>	 <BAY117-W34CE0A5A102BA3E2AAF2419B280@phx.gbl> <ad3aa4c90907071042g16b78eabiea8f55ce48ea7e1d@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: jwilton@bluegecko.net

> On Tue, Jul 7, 2009 at 12:23 PM, Richard Croasmun <rac_oracledba@msn.com 
> > wrote:
>      ...I would say that all the points about log size, frequency of  
> log switches, number of online logs etc would apply even when the DB  
> is NOT in archive log mode.  The only exception would be having  
> enough online logs (or large enough logs) such that the copy of a  
> particular log finishes before the database wants to use that online  
> redo log again.  ...  Am I missing anything here?

On Jul 7, 2009, at 10:42 AM, Andrew Kerber wrote:
> Uh, Yes.  If you are not in archive log mode, the redo log is not  
> copied to the archivelog, so there is no overhead on the switch.   
> When you are not in archive log mode, you just switch to the next  
> redo log and keep going, overwriting what was in the log previously.

I think some of the "overhead" people have been mentioning includes  
the cost of log switch checkpoint, which rightly or wrongly, drives  
some of the effort to size logs for switching at particular  
intervals.  I agree that the greatest possible detractor from  
performance with archivelog mode is log copy.  To determine if  
archivelog mode has any performance impact, the measurement should be  
whether 'log file parallel write' time for LGWR increases when ARCn  
are writing.

Regards,

Jeremiah Wilton
Blue Gecko, Inc.
http://www.bluegecko.net
--
http://www.freelists.org/webpage/oracle-l