default value of db_file_multiblock_read_count
Hi,
I have 10gr2(10.2.0.4.0) database used for datawarehouse purpose. DB is hosted on IBM server with 8k block size.I checked the following parameters in database as well :
db_block_size integer 8192
db_file_multiblock_read_count integer 128
I also read that onw should not set db_file_multiblock_read_count( http://www.dba-oracle.com/t_automatically_tuned_multiblock_reads.htm )
then I checked the following query :
select * from gv$parameter where name='db_file_multiblock_read_count' ;
INST_ID NUM NAME TYPE VALUE DISPLAY_VALUE ISDEFAULT ISSES_MODIFIABLE ISSYS_MODIFIABLE ISINSTANCE_MODIFIABLE ISMODIFIED ISADJUSTED ISDEPRECATED DESCRIPTION UPDATE_COMMENT HASH
I have 10gr2(10.2.0.4.0) database used for datawarehouse purpose. DB is hosted on IBM server with 8k block size.I checked the following parameters in database as well :
db_block_size integer 8192
db_file_multiblock_read_count integer 128
I also read that onw should not set db_file_multiblock_read_count( http://www.dba-oracle.com/t_automatically_tuned_multiblock_reads.htm )
then I checked the following query :
select * from gv$parameter where name='db_file_multiblock_read_count' ;
INST_ID NUM NAME TYPE VALUE DISPLAY_VALUE ISDEFAULT ISSES_MODIFIABLE ISSYS_MODIFIABLE ISINSTANCE_MODIFIABLE ISMODIFIED ISADJUSTED ISDEPRECATED DESCRIPTION UPDATE_COMMENT HASH
0