First page Back Continue Last page Graphics

Multi-Block Reads

Notes:

We can easily demonstrate the impact of multi-block reads on the optimizer’s decision making. First, I disable by setting db_file_multiblock_read = 1. Index access is now favored. However, when Oracle will read 32 blocks in a single I/O, the multi-block full scan is chosen.