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

Thread: Parameters

  1. 03-27-2001, 04:14 AM #1
    alexandre
    alexandre is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 03-27-2001, 04:47 AM #2
    raghucharan
    raghucharan is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  3. 03-27-2001, 07:24 AM #3
    pando
    pando is offline Pando & Company
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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