-
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
In god i trust
-
Hi,
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|