Re: monitoring checkpoints

"Tanel Poder" <tanel@@peldik.com> wrote in message news:<3f2a39cf_1_at_news.estpak.ee>...
>
> One way would be to:
>
> select checkpoint_change#, checkpoint_time, checkpoint_count from
> v$datafile_header;

Another way is to set log_checkpoints_to_alert = true in init.ora. You'll see this info in alert.log.

Yong Huang Received on Fri Aug 01 2003 - 09:21:05 CDT