Re: Data Buffer Cache

Tanel Poder wrote:
>
> > Certainly the checkpoint time at shutdown can be significant. I always
> > use 'alter system checkpoint / shutdown abort" to shutdown, and I've
> > seen some checkpoints in the minutes range.
>
> Hi!
>
> But how do you know that your checkpoint is completed, because starting
> from 8i incremental checkpointing is used and shutdown abort right after
> alter system checkpoint might shut the db before all datafile headers
> are updated?
>
> Tanel Poder.

An 'alter system checkpoint' waits until the checkpoint is complete

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."