Re: Occasional insert slow down with CBC waits.

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
>

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