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!

How to prevent block corruption

155651Jun 20 2008 — edited Jun 23 2008
Recently there was block corruption in the database and we set the check sum parameters

SQL> alter system set db_block_checking=full scope=both;

System altered.

SQL> alter system set db_block_checksum=full scope=both;

System altered.

After this the throughput reduced by more than 50%. So this option was found to be not suitable. Is there any other method to prevent block corruption.

The block corruption occured for LOB segment stored outside the row ( disable storage in row )

Mohan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2008
Added on Jun 20 2008
#general-database-discussions
5 comments
1,048 views