Re: monitoring checkpoints

From: Tanel Poder <tanel_at_@peldik.com>
Date: Fri, 1 Aug 2003 12:58:37 +0300
Message-ID: <3f2a39cf_1@news.estpak.ee>

Hi!

One way would be to:

select checkpoint_change#, checkpoint_time, checkpoint_count from v$datafile_header;

Note that during a datafile is in backup mode, then checkpoint_change# and time don't change due any checkpoints, only checkpoint_count increases.

But why do you want to do this kind of thing manually? Oracle has well working built in mechanisms for it anyway. Oracle doesn't let any data to get stale anyway as much as it is in it's power.

Tanel.

"Francesco" <fmarchioniNIENTESPAM_at_libero.it> wrote in message news:MeoWa.218764$lK4.6397944_at_twister1.libero.it...
> Hi all,
> I'd like to monitor when last checkpoint executed on a datafile, in order
> to force it -if data's going to be stale-. How can I extract that
> information ?
> Thanks
> Francesco
>
>
Received on Fri Aug 01 2003 - 04:58:37 CDT