enq: CR - block range reuse ckpt
Short Description
Enqueue wait on checkpoint.
Additional Information​
An enqueue is a wait for a resource held by another.
Undocumented but Jonathan Lewis and Tanel Poder reference checkpoints around object dropping. It is necessary to checkpoint segments about to be dropped to ensure that no dirty blocks associated with the segment are left orphaned in the buffer cache.
How to reduce this wait​
Look for explicit object drop commends, recycle bin purging or partition split commands.
Additional Links​
Tanel Poder Blog - …Purpose of Segment Level Checkpoint…
Oracle-l - enq: CR block range reuse ckpt [mode=6]
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.