Skip to Main Content
Forums

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!

db_file_multiblock_read_count=0

540353Apr 6 2010 — edited Apr 7 2010
Hi,

I am using oracle 11.1.0.6 in HP-UX. in that the db_file_multiblock_read_count was 128 then i changed to 0 by using

alter system set db_file_multiblock_read_count=0 scope=both; but if i checked using show parameter db_file_multiblock_read_count its showing as 128.

i need to set the db_file_multiblock_read_count parameter to 0 without restarting the DB. my db is in spfile.

Rgds
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2010
Added on Apr 6 2010
#general-database-discussions
5 comments
5,309 views