Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy



Oracle 10g db_block_checksum corruption detection

Article by Rampant Author Chris Foot

Memory Corruption Checking

Setting the DB_BLOCK_CHECKSUM system initialization parameter to TRUE notifies DBWR to calculate a value based on the number of bytes in the block and store that value in the cache header of every data block when writing it to disk. This calculated number is called a checksum. Checksums are verified when the block is read and is used by Oracle to detect corruption caused by the various components of disk storage systems.

In Oracle 10G R2, administrators can set DB_BLOCK_CHECKSUM to FULL to notify Oracle to verify the checksum as it is being transferred from one memory construct to another (i.e. user session to buffer cache). This improves Oracle's capability of identifying block corruptions and is particularly useful when propagating blocks to standby databases.




 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks