Re: High Buffer busy waits
From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Mon, 31 Jul 2023 19:49:10 -0400
Message-ID: <CAMHX9JLLgNzkmivp-4tuq8=PFjBsq-Ai5OuHWqayh4x+JmTWqA_at_mail.gmail.com>
Date: Mon, 31 Jul 2023 19:49:10 -0400
Message-ID: <CAMHX9JLLgNzkmivp-4tuq8=PFjBsq-Ai5OuHWqayh4x+JmTWqA_at_mail.gmail.com>
Reading through other responses - it could of course be a bug too (when you
hit a bug, all bets are off).
On Mon, Jul 31, 2023 at 7:45 PM Tanel Poder <tanel_at_tanelpoder.com> wrote:
> You need to make your checkpoints faster, so that they don't get into the
> way of log file switches. You have a DBWR write I/O problem, not a LGWR or
> buffer busy wait problem (DBWR is the ultimate blocker in the wait chain).
> Increasing/adding redologs may help to reduce these log switch
> waits/symptoms, but ultimately DBWR is not keeping up with syncing enough
> dirty buffers to disk (so that older redologs could be overwritten).
>
>>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 01 2023 - 01:49:10 CEST