Re: Occasional insert slow down with CBC waits.

Thanks Lothar and Sayan for your inputs .

On Thu, 14 Apr 2022 at 9:55 PM, Sayan Malakshinov <xt.and.r_at_gmail.com> wrote:

> Hi Goti,
>
> The easiest way to fix CBC on lob index is to use partitioning option:
> just make that table partition. For example partition by hash
>
>
>
> Best regards,
> Sayan Malakshinov
> Oracle performance tuning expert
> Oracle Database Developer Choice Award winner
> Oracle ACE
> http://orasql.org
>
> чт, 14 апр. 2022 г., 18:41 Goti <aryan.goti_at_gmail.com>:
>
>> Hi,
>>
>> ENV: Oracle 12.1.0.2 on RHEL 7.
>>
>> There is one single pconventional insert which slows down occasionally.
>> The wait event during the slow down is "latch: cache buffer chains". Using
>> Tanel Poder's latchprofx.sql , it was identified that the wait event was
>> mainly for the LOB segment with 1 level bmb as the block class. Details are
>> there in the gists below. Is there any way to identify what is causing this
>> and how the issue can be fixed?
>>
>> https://gist.github.com/aryangoti/06bcd2ead5efbea910afa4e7e5af5e4a
>>
>> https://gist.github.com/aryangoti/7d462225877c648f8a88b669b4b68b08
>>
>>
>> Thanks,
>>
>> Goti
>>
> --
Thanks,

Goti

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