Re: db file multiblock read count
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 15 Jan 2021 21:44:00 -0500
Message-ID: <5b9efe82-f3f1-53ce-59ec-a154eaa4bbaf_at_gmail.com>
Date: Fri, 15 Jan 2021 21:44:00 -0500
Message-ID: <5b9efe82-f3f1-53ce-59ec-a154eaa4bbaf_at_gmail.com>
I fully agree. Oracle will try to set it to the maximum size of an atomic I/O operation on the given platform. For Linux, it's 1MB. That's why the default with 8K blocks is 128: 8K*128 = 1 MB.
On 1/15/21 7:42 PM, Andrew Kerber wrote:
> Since 10gr2, it has always been best to not set this and let oracle
> determine a good value.
-- Mladen Gogala Database Consultant http://mgogala.byethost5.com -- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 16 2021 - 03:44:00 CET