Performance after increasing SGA on windows
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Performance after increasing SGA on windows

  1. #1
    Join Date
    Apr 2004
    Posts
    13

    Performance after increasing SGA on windows

    I increased shared_pool_size and db_cache_size on windows, since then the perfoamce is degraded. Can someone help me on increasing the performance. The system has the following parameters:

    Physical mem :512MB
    Available :108,892KB
    Virtual memory:1,801,760KB
    Available : 928,128KB
    No of CPU's 1
    No of instances 1
    SGA of instance : 96.932
    Shared_pool :48MB
    Db_cache_size:32MB
    SGA Max size : 129.069

    And i increased Shared_pool_size to 72MB
    and db_cache_size :52MB

    Thanks in advance.
    Last edited by kiranakula76; 04-21-2004 at 10:49 AM.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    42K and 58K

    errr are you joking..?! not even 1 MB!

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Maybe you introduced swapping on the SGS -- 512Mb of physical memeory is really small for Oracle.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    512Mb of physical memeory is really small for Oracle.
    Depends what you are doing - my test/dev has four instances on a machine with 512MB, performance is limited mainly by the **** RAID-5. The SGA's are 50-125MB.

    Naively, paging allows you to over-allocate SGA - anything not actually needed will get paged out.

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by pando
    42K and 58K

    errr are you joking..?! not even 1 MB!
    I dont see these figures in his post.. are you joking?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Apr 2004
    Posts
    13
    Originally posted by DaPi
    Depends what you are doing - my test/dev has four instances on a machine with 512MB, performance is limited mainly by the **** RAID-5. The SGA's are 50-125MB.

    Naively, paging allows you to over-allocate SGA - anything not actually needed will get paged out.
    Not KB it is MB

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by abhaysk
    I dont see these figures in his post.. are you joking?
    Original poster edited it..
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  8. #8
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by SANJAY_G
    Original poster edited it..
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  9. #9
    Join Date
    Apr 2004
    Posts
    13
    Originally posted by SANJAY_G
    Original poster edited it..
    What do u mean??I did't get u man.

  10. #10
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by kiranakula76
    What do u mean??I did't get u man.
    Look for "Last edited by kiranakula76 on 04-21-2004 at 11:49 PM" at the bottom of your first post.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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