Re: Finding the checkpoint frequency
- From: Kevin Lidh <kevin.lidh@xxxxxxxxx>
- To: sharmakdeep_oracle@xxxxxxxxx
- Date: Wed, 10 Sep 2008 11:33:04 -0600
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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
