|
CI - CROSS INSTANCE CALL
. V7 - Extent-based checkpoints. DBWR has to find and flush all blocks from extents
used in a parallel query prior to doing direct reads
. V8 - Taken out to checkpoint an object or block range (see 'object flush calls');
used to flush dirty buffers to disk prior to a direct read operation (PQ)
. exacerbated by an overly large buffer cache and parallel query combination |
|