Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

db_block_checking and db_block_checksum

Dude!Dec 13 2010 — edited Dec 16 2010
Hi,

According to Oracle 11g documentation:

DB_BLOCK_CHECKING checks a block by going through the data in the block, making sure it is logically self-consistent. It typically causes 1% to 10% overhead.
DB_BLOCK_CHECKSUM determines whether DBWn and the direct loader will calculate a checksum when writing it to disk. It causes a 4% to 5% overhead in FULL mode.

If I understand correctly, then DB_BLOCK_CHECKING prevents logical block corruption, and DB_BLOCK_CHECKSUM physical corruption. Is this correct?

I assume that when I enable DB_BLOCK_CHECKING then I do not need DB_BLOCK_CHECKSUM anymore, correct?

Also, can I enable block_checking when rman creates a backupset, or do I need to use restore validate after the backup??

Thanks!

Edited by: Dude on Dec 13, 2010 5:03 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2011
Added on Dec 13 2010
#general-database-discussions
18 comments
6,604 views