All,
My understanding is, DB_FILE_MULTI_BLOCK_READ_COUNT is used when optimizer use the full table scan.
How do we set the value for db_file_multiblock_read_count.
Is this the right formula to determine the DB_FILE_MULTIBLOCK_READ_COUNT? If so, how do we determine max I/O chunk size value?
max I/O chunk size
db_file_multiblock_read_count = -------------------
db_block_size