RE: Way to much log switching!!!

From: Jeremiah Wilton <jwilton_at_speakeasy.net>
Date: Wed, 30 Jun 2004 14:14:05 -0700 (PDT)
Message-ID: <Pine.LNX.4.58.0406301411330.18778@shell2.speakeasy.net>

On Wed, 30 Jun 2004 Rajesh.Rao_at_jpmchase.com wrote:

> I dont think recovery is the issue. The issue could be performance, caused,
> if not by frequent checkpointing, then by log switches. Does redo logging
> not freeze during a log switch, since log buffer space wont be allocated
> until the log switch is complete. So, in an hour, is it not better to have
> 3 log switches than 30?

Well this is not normally a significant factor in most environments.

But if someone thinks that people are spending time waiting on log switches, they can always look at v$system_event and find out if 'log file switch' comprises any significant proportion of waits.

Otherwise, it is just conjecture, right?

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jun 30 2004 - 16:10:45 CDT