Re: 10210, 10211, and 10231

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 20 Jan 1999 20:54:55 GMT
Message-ID: <36a636e7.8101942@news.siol.net>

On Wed, 20 Jan 1999 23:28:11 +0800, Reid Lai <reidlai_at_hk.super.net> wrote:

>Hi There,
>
>Is there any side effect other than disk I/O overhead if I always set
>database event 10210, 10211, and 10231 in INIT.ORA? And are these event
>applied only when the block is being read? Are they also applied for
>writing block or turn on DB_BLOCK_CHECKSUM instead?

AFAIK this events don't cause any I/O overhead, they would only cause some aditional CPU overhead. And yes, I understand that this additional checking is performed only when blocks are read into the buffer cache.

>--
>Best Regards,
>
>Reid Lai <reidlai_at_hk.super.net>

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Jan 20 1999 - 14:54:55 CST