_db_writer_verify_writes hidden parameter & db_block_checksum

From: <rama.ari_at_accenture.com>
Date: Thu, 22 Jan 2009 10:28:34 -0500
Message-ID: <ED8E9B3F84B33441B49A70715CCA55EBA39B9C72AE_at_AMRXM3111.dir.svc.accenture.com>


We have block corruption in Oracle RAC ASM environment. We are evaluating to setup oracle parameters to debug/prevent block corruption when it happens next time. Did any one used _db_writer_verify_writes parameter? I was in impression that it helps to direct the DBWR to re-read every block after it writes it out to make sure the write operation did happen as planned. I didn't find much information in Metalink.

We are also evaluating setting up DB_BLOCK_CHECKSUM parameter. I would really appreciate if you had any lesions learned with these parameters (like performance degradation, etc)

Rama Ari | Accenture
Technology Consulting
* Mobile: +1 (610) 203-0661

This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.

Received on Thu Jan 22 2009 - 09:28:34 CST

Original text of this message