Finding the checkpoint frequency

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Wed, 10 Sep 2008 09:39:06 -0700 (PDT)
Message-ID: <157799.65415.qm@web52805.mail.re2.yahoo.com>


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
Received on Wed Sep 10 2008 - 11:39:06 CDT

Original text of this message