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

Thread: Shared_pool

  1. #1
    Join Date
    Aug 2001
    Location
    Dubai
    Posts
    41

    Hi,

    I wanaa Know when we say the performance can be increased by increasing the shared_pool size :- what exactly the size contribute its memory RAM or hard disk

    Thanks
    Bj

  2. #2
    Join Date
    Jun 2001
    Posts
    87
    The shared pool should be fully loaded in memory. If not paging and swapping will result and this is very bad for any Database.

    If the shared pool is already in memory, and you have all the necessary procedures etc already pinned in the shared pool, then increasing the shared_pool_size will bring little benefit.

    This will only result in you taking memory from the OS. Increasing the shared_pool_size means allocating RAM to the shared pool.

  3. #3
    Join Date
    Aug 2001
    Location
    Dubai
    Posts
    41

    THANK YOU DS FOR THE REPLY......

    BJ

  4. #4
    Join Date
    Aug 2001
    Location
    Dubai
    Posts
    41

    Hi DJ One more things i want to know that if ram size is less , Is their any way to increase the Shared_pool_size performance

  5. #5
    Join Date
    Jun 2001
    Posts
    87
    Not that I know of. The bottom line is SGA must fit in memory or be prepared to put up with swapping and Paging. This will dramatically slow your database.

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