Re: Finding the checkpoint frequency

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Thu, 11 Sep 2008 08:20:03 -0700 (PDT)
Message-ID: <381871.62593.qm@web52811.mail.re2.yahoo.com>

Yes, that's the same recommendation I got from a few others too.

Thanks for replying,
Deepak

• Original Message ---- From: "Adams, Matthew (GE Indust, ConsInd)" <MATT.ADAMS_at_GE.COM> To: oracle-l_at_freelists.org Sent: Thursday, September 11, 2008 8:46:13 AM Subject: RE: Finding the checkpoint frequency

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

---

 From: oracle-l-bounce_at_freelists.org
[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: 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 Thu Sep 11 2008 - 10:20:03 CDT