Name
DB_BLOCK_CHECKPOINT_BATCH
Synopsis
Value: 0-derived
Default: 8
Dynamic: ALTER SYSTEM
Specifies the number of buffers that will be added to each batch of buffers that DBWR writes in order to advance checkpoint processing. Reducing DB_BLOCK_CHECKPOINT_BATCH prevents the I/O system from being flooded with checkpoint writes and allows other modified blocks to be written to disk. Setting it to a higher value allows checkpoints to complete more quickly. Setting DB_BLOCK_CHECKPOINT_BATCH to zero causes the default value to be used. If the specified value is too large, Oracle limits it to the number of blocks that can be written in a database writer write batch. Obsolete 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.