From: Allen Kirby <akirby@att.com>
Subject: Re: REDO log shifts are blocking for DB updates !!!
Date: 1997/03/03
Message-ID: <331ACD78.17FC@att.com>#1/1
References: <3300699E.3C39@nera.no> <331bfdd4.12777226@news.centroin.com.br> <3318223c.377288753@news>
To: smurray@bah.com
Organization: AT&T - ITS Production Services
Reply-To: akirby@att.com
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools



Shane Murray wrote:
> 
> At a log switch (possibly at every chkpt, I can't remember) the SGA is
> flushed which takes time and resources.  In order to minimize the
<snip>

Actually, the dirty blocks in the SGA are flushed at each checkpoint,
and a log switch forces a checkpoint.  In this case they may want to
do frequent checkpoints to reduce the amount of time each one takes.
And I thought our users had strict response-time requirements!
-- 
---
Allen Kirby			AT&T ITS Production Services
akirby@att.com			Alpharetta, GA.