Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Changing db_file_multiblock_read_count

661363Sep 23 2009 — edited Sep 24 2009
Hi All,

We are in 10.2.0.4 and we have the current value of db_file_multiblock_read_count as 8.

We want to remove this value from init and want oracle to set the value. At present we can not shutdown the database. So i changed it through

alter system set db_file_multiblock_read_count=0 scope=both;

it completed successfully.

But when i see a explain plan for a query, its showing the same cost as per the value db_file_multiblock_read_count as 8.

But it showing 128 in the v$parameter.

Please advice, if this parameter change requires a reboot.

Thanks & Regards,
Rakesh
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 22 2009
Added on Sep 23 2009
7 comments
5,496 views