SGA Sizing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SGA Sizing

  1. #1
    Join Date
    Nov 2002
    Location
    INDIA
    Posts
    38

    SGA Sizing

    Hi Guys,
    I am presently learning to do SGA Sizing.Given a situation where I am asked to break up the SGA into various compartments depending on the various init parameters.
    1) I want to map the initialisation parameters to various compartments.
    2) I want to derive a formulas for determining the sizes of various compartments.
    3) What do the Control Structures in the Shared Pool Actually Do and which parameter determines its size.
    4) What do the Locks and Structures part in the Library cache do and which parameter determines its size.

    Thanking you in advance,

    Paddy

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588

  3. #3
    Join Date
    Nov 2002
    Location
    INDIA
    Posts
    38
    Thanks for the reply Sameer...
    I have been reading this ie the oracle online help..But I have not been able to...actually the point is that I want to know which parameter determines the Control structures in the Shared Pool..
    Info regarding Locks and structures...and The parameter mapping to that various compartments..

    Thanks in advance,

    Paddy

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