db_file_multiblock_read_count  8

 

3.只修改spfile中的值

SQL> alter system set db_file_multiblock_read_count=64 scope=spfile;

系统已更改。

 

SQL> select name,value from v$parameter where name='db_file_multiblock_read_count';

NAME                           VALUE
IXDBA.NET技术社区
------------------------------ ------------------------------
db_file_multiblock_read_count  8

 

SQL> select name,value from v$system_parameter where name='db_file_multiblock_read_count';

NAME                           VALUE
------------------------------ ------------------------------
db_file_multiblock_read_count  8

 

SQL> select name,value from v$spparameter where name='db_file_multiblock_read_count';

NAME                           VALUE
------------------------------ ------------------------------
db_file_multiblock_read_count  64

 

另外还有v$parameter2和v$system_parameter2，这两个和v$parameter,v$system_parameter的区别在于，对一些有多个值的参数，前者分成多条记录，后者这是一条记录：

SQL> select name,value from v$parameter where name='control_files';

NAME                           VALUE
------------------------------ ----------------------------------------
control_files                  D:\ORACLE\ORADATA\NINGOO\CONTROL01.CTL,
                               D:\ORACLE\ORADATA\NINGOO\CONTROL02.CTL,
                               D:\ORACLE\ORADATA\NINGOO\CONTROL03.CTL

已选择 1 行。

 

SQL> select name,value from v$parameter2 where name='control_files';

NAME                           VALUE
------------------------------ ----------------------------------------
control_files                  D:\ORACLE\ORADATA\NINGOO\CONTROL01.CTL
control_files                  D:\ORACLE\ORADATA\NINGOO\CONTROL02.CTL
control_files                  D:\ORACLE\ORADATA\NINGOO\CONTROL03.CTL