Re: Overlapping checkpoint question?

"Sybrand Bakker" <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in message news:jscdtv8a96b7ksme2iunokksihf1377lg1_at_4ax.com...
> On 9 Dec 2003 20:23:45 -0800, domenicg_at_hotmail.com (Domenic G.) wrote:
>
> >This may seem like a dumb question, but when a checkpoint runs, does
> >it keep running until all the dirty buffers are flushed down, even the
> >ones that become dirty while the checkpoint is running -- OR, does the
> >checkpoint only flush what was dirty when it started (ie, <= SCN).
> >
> >So if a checkpoint is issued before a previous checkpoint completes,
> >do they queue up, or does Oracle simply ignore the 2nd checkpoint?
> >
> >Dom.
>
> They queue up
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

They don't, actually.

The first checkpoint is extinguished, and the second takes over from where the first one left off. I suppose practically it looks much the same, however you describe it. But in terms of process messaging etc, it's a kill followed by a new checkpoint.

Regards
HJR

-- 
------------------------------------
Oracle insights at www.dizwell.com
------------------------------------