Changing db_file_multiblock_read_count
661363Sep 23 2009 — edited Sep 24 2009Hi 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