Re: Delayed block clean out on Exadata DW
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Sat, 30 Jan 2021 11:29:53 +0000
Message-ID: <CAGtsp8nTd59Gt5DyowPtn3TeNbSN5GJiDtD3vpkabD7QVyUH2g_at_mail.gmail.com>
Date: Sat, 30 Jan 2021 11:29:53 +0000
Message-ID: <CAGtsp8nTd59Gt5DyowPtn3TeNbSN5GJiDtD3vpkabD7QVyUH2g_at_mail.gmail.com>
Could you start by supplying the URLs of two or three of the ones you think
are most relevant, please.
It's not just delayed block cleanout that could cause this to happen.
Also, which version of Oracle are you using.
Regards
Jonathan Lewis
On Fri, 29 Jan 2021 at 20:29, Moustafa Ahmed <moustafa_dba_at_hotmail.com> wrote:
> Hello listers
>
> There are many articles talking about seeing massive cell single block
> physical read on Exadata combined with delayed block clean outs...
> What are the best practices to avoid and mitigate such catastrophic thing
> ?--
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 30 2021 - 12:29:53 CET