Parameters
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Parameters

  1. #1
    Join Date
    Jun 2000
    Location
    Maputo, Maputo-Mozambique
    Posts
    96
    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

  2. #2
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    Hi,
    You can change the values and it wont effect your production database,if the memory of that machine is increased.

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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
  •  



Click Here to Expand Forum to Full Width