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