I upgrade the server memory and i would like to increase the
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?
In god i trust
You can change the values and it wont effect your production database,if the memory of that machine is increased.
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
Click Here to Expand Forum to Full Width