Name

DB_BLOCK_CHECKING

Synopsis

Value: TRUE | FALSE

Default: FALSE

Dynamic: ALTER SYSTEM, ALTER SESSION

Specifies whether data blocks are checked for corruption before being written. Setting this parameter to TRUE will result in a performance penalty of up to 10%, so use it with caution. New with Oracle8i.

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.