RE: Finding the checkpoint frequency
Date: Thu, 11 Sep 2008 09:46:13 -0400
Perhaps the LOG_CHECKPOINTS_TO_ALERT init.ora parameter is what you're looking for.
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Deepak Sharma Sent: Wednesday, September 10, 2008 12:39 PM To: oracle-l_at_freelists.org
Subject: Finding the checkpoint frequency
We are NOT seeing the checkpoint-related message in Alertlog such as this:
Beginning log switch checkpoint up to RBA [0x1a01.2.10], SCN:
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