Parameters

[alexandre]

I upgrade the server memory and i would like to increase the
following parameters
DB_BLOCK_BUFFERS and SHARED_POOL_SIZE and decrease the SHARED_POOL_RESERVED_SIZE as well.
Question is, there any special consideration to follow before altering them? is it possible to change the DB_BLOCK_BUFFERS on production env? any hazards?

Regards
Alexandre

[raghucharan]

Hi,
You can change the values and it wont effect your production database,if the memory of that machine is increased.

[pando]

If you have enoguh memory of course you can increa db_block_buffers. The point would be do you really need to increase it? You should check hit ratio and system events first