An interesting case of ‘enq: CR – block range reuse ckpt’, CKPT blocking user sessions …

Hi All, Last week we faced an interesting issue with one of the production system which was recently migrated from Oracle 12.2. to 19.15. The setup was running on a VMWare machine with limited resources. It all started when the application team started reporting slowness in their daily scheduled jobs and other ad-hoc operations, when … Continue reading An interesting case of ‘enq: CR – block range reuse ckpt’, CKPT blocking user sessions …