Database DataWarehousing (MOSC)

MOSC Banner

default value of db_file_multiblock_read_count

edited Sep 7, 2011 5:08AM in Database DataWarehousing (MOSC) 7 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center