December 2002
Intermediate to advanced
928 pages
85h 29m
English
DB_BLOCK_CHECKPOINT_BATCH
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.