Re: High Buffer busy waits
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 28 Jul 2023 21:31:03 -0400
Message-ID: <a013ba85-0de7-10f8-cc18-4a39626779c8_at_gmail.com>
Date: Fri, 28 Jul 2023 21:31:03 -0400
Message-ID: <a013ba85-0de7-10f8-cc18-4a39626779c8_at_gmail.com>
On 7/27/23 09:35, Lothar Flatz wrote:
>
> Hi,
>
> Just being curious:
> does anyone know if current_obj# is pointing to the correct object? I
> did some research on "latch cache buffer chains" and found out that
> current_obj# is unreliable for that wait event.
Hi Lothar,
Which version did you test it in? I wonder, because I have no problems with 19C. I am using the hot block method described here:
http://ksun-oracle.blogspot.com/2014/03/hot-block-identification.html
I apologize for the article being a tad old.
Regards
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Sat Jul 29 2023 - 03:31:03 CEST