Re: enq: CR - block range reuse ckpt

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 18 Mar 2019 02:16:02 -0400
Message-ID: <c48ee6ab-4da3-4692-3c36-b699e784c222_at_gmail.com>

Since the TRUNCATE is a DDL operation which changes the whole outlook of the table affected, including data object id, you need to do a segment checkpoint. None of your buffers in SGA from the table is valid any more. You need so called "segment check point" or, as newer versions of Oracle call it, "block range reuse" checkpoint.

Regards

On 3/15/19 7:50 AM, Howard Latham 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
>
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


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

Received on Mon Mar 18 2019 - 07:16:02 CET

This message: [ Message body ]
Next message: Seth Miller: "Re: Duplicate for standby fails with ORA-01580, ORA-27040"
Previous message: Neil Chandler: "Re: ADG lag after upgrading to 12.1"
In reply to: Howard Latham: "enq: CR - block range reuse ckpt"
In reply to Howard Latham: "enq: CR - block range reuse ckpt"
Next in thread: Seth Miller: "Re: Duplicate for standby fails with ORA-01580, ORA-27040"

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

Original text of this message