The db_file_multiblock_read_count initialization parameter determines the
maximum number of database blocks read in one I/O operation during a full
table scan. The setting of this parameter can reduce the number of I/O
calls required for a full table scan, thus improving performance.

Narayan


Oracle LazyDBA home page