Re: db file multiblock read count
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Fri, 15 Jan 2021 18:42:16 -0600
Message-Id: <D60CB3AD-2E70-4C6B-9955-020FD8A78E23_at_gmail.com>
Date: Fri, 15 Jan 2021 18:42:16 -0600
Message-Id: <D60CB3AD-2E70-4C6B-9955-020FD8A78E23_at_gmail.com>
Since 10gr2, it has always been best to not set this and let oracle determine a good value.
Sent from my iPhone
> On Jan 15, 2021, at 4:18 PM, Moustafa Ahmed <moustafa_dba_at_hotmail.com> wrote:
>
> Hello
>
> There are many opinions out there about the right value for
> db file multiblock read count
> And the more I look it seems like it started to be of less significance than 10 years ago!
> Say a value of 1024 which is considerably high
> On Exadata and a DW system
> What would be the concerns with that?
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 16 2021 - 01:42:16 CET