Increase SGA
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Increase SGA

  1. #1
    Join Date
    Feb 2001
    Posts
    2
    Hi,
    I need to increase the SGA on the database which is currently at 100MB. I need to make it 150MB.
    What are the parameters to change in the init.ora file. Oracle v 8

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    SGA Primarily made up of db_block buffers, shared pool and log buffer. Modify parameters appropriate to your environment requirement or current memory issues.
    Reddy,Sam

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    I'm not sure abot 8, 8i the SGA is made up of the following

    (db_block_buffers * db_block_size)+ shared_pool_size + log_buffers + large_pool_size + java_pool_size

    Increasing the db_block_buffers would enhance the reads
    similarly increasing the shared pool size would increase the query performance, large_pool is normally used when there arent enough space in the shared pool to do a single fetch

    I hope this would clear your doubts

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Feb 2001
    Posts
    2
    Thanks sambavan and sreddy

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