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

Thread: Performance after increasing SGA on windows

Threaded View

  1. 04-21-2004, 09:32 AM #1
    kiranakula76
    kiranakula76 is offline Junior Member
    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.
    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