RE: db_file_multiblock_read_count

From: Allen, Brandon <>
Date: Mon, 29 Sep 2008 16:47:12 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C450D842C3D@NT15.oneneck.corp>

How do you know you're "being ignored"? Just because it shows a value of 128 doesn't mean your "reset" isn't working - maybe 128 is the value that Oracle is coming up with? Try this:

select isdefault from v$parameter where name = 'db_file_multiblock_read_count';

If it's not the default, you might want to try this:

alter system reset db_file_multiblock_read_count scope=spfile sid = '*';

Then bounce your instance and check again.


Received on Mon Sep 29 2008 - 18:47:12 CDT

Original text of this message