SGA (Shared Pool SQL Area Buffer)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SGA (Shared Pool SQL Area Buffer)

  1. #1
    Join Date
    Jul 2001
    Posts
    108
    Hello,

    I found that the system has allocated 29% of SGA to SQL Area, which is in shared pool. Like wise the system also allocated 12% of SGA to Library Cache.

    Is there any way that I can increase the % amount of allocation to a particular buffer like SQL Area from 29% (Current value) to 40% with out increasing the shared_pool_size parameter?

    Thanks
    Best regards,
    Nikee

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    It is oracle dependent, so NO.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jul 2001
    Posts
    108

    (Shared Pool SQL Area Buffer)

    Hello Sam,

    If it is Oracle dependent, does Oracle allocate the percentage dynamically or itís a constant value?

    Thanks
    Regards,
    Nikee

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Its a dynamic area and during the high load period you could notice things to hike up. As far as the calculation goes, I'm illitrate on it...

    Here is a link that would help you to tune the shared pool.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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