RE: Finding the checkpoint frequency

  • From: "Adams, Matthew (GE Indust, ConsInd)" <MATT.ADAMS@xxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 11 Sep 2008 09:46:13 -0400

Perhaps the LOG_CHECKPOINTS_TO_ALERT  init.ora parameter is what you're
looking for.


From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Deepak Sharma
Sent: Wednesday, September 10, 2008 12:39 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Finding the checkpoint frequency

We are NOT seeing the checkpoint-related message in Alertlog such as

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


Other related posts: