Re: enq: CR - block range reuse ckpt

From: Sanjay Gaur <sanjaylko86_at_gmail.com>
Date: Fri, 15 Mar 2019 22:55:02 +0530
Message-ID: <CAPqDFzwAwqBwE=5Y2j3e57MrfL2uY1ogFbgxwA4tx0Gc+L6gHg_at_mail.gmail.com>

Hi,

Tanel Poder has written a good post on this blog about this.

https://blog.tanelpoder.com/2011/07/06/what-is-the-purpose-of-segment-level-checkpoint-before-droptruncate-of-a-table/

Regards,
Sanjay

On Fri, 15 Mar 2019 at 17:22 Howard Latham <howard.latham_at_gmail.com> wrote:

> Oracle .11 RHEL6
>
> HI folks
>
> A developer truncated a 50 Million row table and now the database is very
> very slow
>
> we can see this wait - Any Ideas please?
>
> enq: CR - block range reuse ckpt
>
>
>
> Howard A. Latham
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 15 2019 - 18:25:02 CET

This message: [ Message body ]
Next message: Charles Schultz: "Re: A mystery: use of deprecated crypto cipher aes-ecb by /u01/app/oracle/product/12.1.0.2.home1/bin/oracle"
Previous message: Sayan Malakshinov: "Re: Keep buffer cache question"
In reply to Howard Latham: "enq: CR - block range reuse ckpt"
Next in thread: Mladen Gogala: "Re: enq: CR - block range reuse ckpt"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message