For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi all,
I try to drop a user but my session hangs waiting for enq: CR - block range reuse ckpt. I understand this has to do with the CKPT process trying to checkpoint the dirty buffers on cache/disk. But i am not very clear of the situation. The session for the CKPT process is idle with wait event rdbms ipc message. I have not got this problem before when i dropped users. Can anyone help me to solve this issue??