Finding the checkpoint frequency
- From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 10 Sep 2008 09:39:06 -0700 (PDT)
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
Other related posts:
