RE: Recommended number of redo log switches per hour

On Thu, 14 Mar 2002, Post, Ethan wrote:

> (HJR) recommends one switch per day (manually) if possible and not
> more than once per hour. This is all to limit when a checkpoint
> actually occurs.

Ok, this must by a troll. Once a day? Manually? Is he kidding? A checkpoint is a normal thing. It is minimally impactful, and takes up a very small proportion of the DBW0 write batch. Real sites checkpoint all the time under heavy usage conditions and nobody gets hurt.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton



> -----Original Message-----


> Sent: Thursday, March 14, 2002 8:19 AM

> To: Multiple recipients of list ORACLE-L

> 

> An Oracle Support technician recommended that I try to aim for three log

> switches per hour, during busy times.

> 

> According to the throughput I got yesterday between 3 and 4 o'clock PM, my

> redo log files would each have to be 1G in size.

> 

> That seems much too large to me, and I am not even sure it is possible to

> create redo log files that size.  Under Oracle 7.3. the largest I could

> create on Tru64 UNIX 4.0g was 40M redo log files.

> 

> Is this another "rule of thumb" that should go down the drain?


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).