OWI之db file scattered read

Oracle在执行全表扫描(full table scan）或全索引扫描(index full scan)时,为保障性能,尽量一次性读取多个块,这称为Multi Block I/O.

每次执行Multi Block I/O,都会等待物理I/O结束，此时等待db file scattered read 事件。

利用db file scattered read 等待事件的P1=file#


SQL> show parameter multi

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_file_multiblock_read_count	     integer	 128

SQL> alter system set db_file_multiblock_read_count=10000;

System altered.

SQL>  show parameter multi

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_file_multiblock_read_count	     integer	 4096

SQL>  alter system set db_file_multiblock_read_count=999999999;

System altered.

SQL>  show parameter multi

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_file_multiblock_read_count	     integer	 4096

这个值每个OS都有最大值的限制,可以看到此环境