Re: Finding the checkpoint frequency

SQL> alter system set log_checkpoints_to_alert = true ...

On Wed, 2008-09-10 at 09:39 -0700, Deepak Sharma wrote:
> We are NOT seeing the checkpoint-related message in Alertlog such as this:
>
> Beginning log switch checkpoint up to RBA [0x1a01.2.10], SCN: 0x0000.644a1dbb
> ..
> Completed checkpoint up to RBA [0x1a01.2.10], SCN: 0x0000.644a1dbb
>
>
> Is there a way to enable it so that we see it in alertlog? Any event?
>
> Are there other ways to find out, say, from v$ tables, to see how often are checkpoints happening?
>
> The DB version is 10.2.0.3
>
> Thanks,
> Deepak
>

--
http://www.freelists.org/webpage/oracle-l