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


Other related posts: