一、環(huán)境
Oracle 11g RAC

公司主營業(yè)務(wù)：成都網(wǎng)站制作、成都做網(wǎng)站、移動(dòng)網(wǎng)站開發(fā)等業(yè)務(wù)。幫助企業(yè)客戶真正實(shí)現(xiàn)互聯(lián)網(wǎng)宣傳，提高企業(yè)的競(jìng)爭(zhēng)能力。成都創(chuàng)新互聯(lián)是一支青春激揚(yáng)、勤奮敬業(yè)、活力青春激揚(yáng)、勤奮敬業(yè)、活力澎湃、和諧高效的團(tuán)隊(duì)。公司秉承以“開放、自由、嚴(yán)謹(jǐn)、自律”為核心的企業(yè)文化，感謝他們對(duì)我們的高要求，感謝他們從不同領(lǐng)域給我們帶來的挑戰(zhàn)，讓我們激情的團(tuán)隊(duì)有機(jī)會(huì)用頭腦與智慧不斷的給客戶帶來驚喜。成都創(chuàng)新互聯(lián)推出和平免費(fèi)做網(wǎng)站回饋大家。

二、測(cè)試過程

SQL> show parameter db_file

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_multiblock_read_count        integer     128
db_file_name_convert                 string      /oracle/oradata/, +DATADG
db_files                             integer     200

SQL> set timing on
SQL> select count(*) from tt;

  COUNT(*)
----------
   5524288

Elapsed: 00:00:11.50
SQL> alter system flush buffer_cache;

System altered.

Elapsed: 00:00:00.20
SQL> alter system flush shared_pool;

System altered.

Elapsed: 00:00:00.39
SQL> alter session set db_file_multiblock_read_count=16;

Session altered.

Elapsed: 00:00:00.00
SQL> select count(*) from tt;

  COUNT(*)
----------
   5524288

Elapsed: 00:00:08.91
SQL> alter system flush buffer_cache; 

System altered.

Elapsed: 00:00:00.12

SQL> alter system flush shared_pool;

System altered.

Elapsed: 00:00:00.06
SQL> alter session set db_file_multiblock_read_count=32;

Session altered.

Elapsed: 00:00:00.00
SQL> select count(*) from tt;

  COUNT(*)
----------
   5524288

Elapsed: 00:00:07.87
SQL> alter system flush buffer_cache; 

System altered.

Elapsed: 00:00:00.14
SQL> alter system flush shared_pool;

System altered.

Elapsed: 00:00:00.06
SQL> alter session set db_file_multiblock_read_count=64;

Session altered.

Elapsed: 00:00:00.00
SQL> select count(*) from tt;

  COUNT(*)
----------
   5524288

Elapsed: 00:00:07.05
SQL> alter system flush buffer_cache;

System altered.

Elapsed: 00:00:00.15
SQL> alter system flush shared_pool;

System altered.

Elapsed: 00:00:00.06
SQL> alter session set db_file_multiblock_read_count=128;

Session altered.

Elapsed: 00:00:00.00
SQL> select count(*) from tt;

  COUNT(*)
----------
   5524288

Elapsed: 00:00:06.62
SQL> 
SQL> 

三、小結(jié)
1、對(duì)于全表掃描來說多塊讀，增加每次讀取的塊數(shù)，可以提高性能。
2、在OLTP的系統(tǒng)中建議此參數(shù)設(shè)置為8、16、32
3、在OLAP的系統(tǒng)中建議此參數(shù)設(shè)置為128最大值