Re: db file multiblock read count

From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Fri, 15 Jan 2021 21:44:00 -0500

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

--
//www.freelists.org/webpage/oracle-l

References:
- db file multiblock read count
  - From: Moustafa Ahmed
- Re: db file multiblock read count
  - From: Andrew Kerber

Other related posts:

» db_file_multiblock_read_count
» RE: db_file_multiblock_read_count
» RE: db_file_multiblock_read_count
» RE: db_file_multiblock_read_count
» Re: db_file_multiblock_read_count
» Re: db_file_multiblock_read_count
» RE: db_file_multiblock_read_count
» db_file_multiblock_read_count
» Re: db_file_multiblock_read_count
» RE: db_file_multiblock_read_count
» Re: db_file_multiblock_read_count
» Re: db_file_multiblock_read_count
» Re: db_file_multiblock_read_count
» RE: db_file_multiblock_read_count
» Re: db_file_multiblock_read_count
» RE: db_file_multiblock_read_count
» Re: db_file_multiblock_read_count
» db file multiblock read count- Moustafa Ahmed
» Re: db file multiblock read count- Andrew Kerber
» Re: db file multiblock read count - Mladen Gogala
» Re: db file multiblock read count- Jonathan Lewis
» Re: db file multiblock read count- Neil Chandler
» Re: db file multiblock read count- Frits Hoogland
» Re: db file multiblock read count- Jonathan Lewis
» RE: db file multiblock read count- Clay Jackson (cjackson)
» Re: db file multiblock read count- Tanel Poder