Occasional insert slow down with CBC waits.

From: Goti <aryan.goti_at_gmail.com>
Date: Thu, 14 Apr 2022 21:10:55 +0530
Message-ID: <CAOzfMurgCfCo=_0_vCrHxXStPbCnFV3NdydQhxHn4LCcUJUAHA_at_mail.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

Received on Thu Apr 14 2022 - 17:40:55 CEST

This message: [ Message body ]
Next message: Lothar Flatz: "Re: Occasional insert slow down with CBC waits."
Previous message: sachin pawar: "Re: Suggestions on moving to cloud"
Next in thread: Lothar Flatz: "Re: Occasional insert slow down with CBC waits."
Reply: Lothar Flatz: "Re: Occasional insert slow down with CBC waits."
Reply: Sayan Malakshinov: "Re: Occasional insert slow down with CBC waits."
Reply: Jonathan Lewis: "Re: Occasional insert slow down with CBC waits."

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

Original text of this message