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

Thread: sga size

  1. #1
    Join Date
    Apr 2003
    Posts
    46

    sga size

    when u query the sga view it gives some values such as fixed size,variable size, etc . i want to know what does fixed size comprise of, same with variable size and their meaning.

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    You may find this interesting...
    http://www.adp-gmbh.ch/ora/concepts/sga.html

    HTH.

  3. #3
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233
    Hi,

    Fixed Size
    - Contains general information about the state of the
    database and the instance, which the background processes need
    to access.
    - No user data is stored here.
    - This area is usually less than 100k in size.

    Variable Size
    - This section is influenced by the following init.ora
    parameters :shared_pool_size ,large_pool_size and
    java_pool_size

    Regards,
    Nir

  4. #4
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by nir_s
    ...less than 100k in size.
    In 9i, this is more than 100k in size.

    TST: SYS> show sga

    Total System Global Area 118255568 bytes
    Fixed Size 282576 bytes
    Variable Size 83886080 bytes
    Database Buffers 33554432 bytes
    Redo Buffers 532480 bytes

  5. #5
    Join Date
    Jan 2001
    Location
    Vancouver, Canada
    Posts
    87
    Hi ggnanaraj,

    Please read up Oracle 9i DBA Adminstration Guide available for download from Oracle Technology Network in .pdf format.

    Hope this helps!!

    MZ
    Mohammad Zahid
    Software Developer
    Database Management Applications.
    Vancouver, Canada
    E-mail: mzahid@shaw.ca

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: sga size

    Originally posted by ser
    when u query the sga view it gives some values such as fixed size,variable size, etc . i want to know what does fixed size comprise of, same with variable size and their meaning.
    http://asktom.oracle.com/pls/ask/f?p...:365088445659,

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    May 2001
    Posts
    736
    Originally posted by mzahid
    Hi ggnanaraj,

    Please read up Oracle 9i DBA Adminstration Guide available for download from Oracle Technology Network in .pdf format.

    Hope this helps!!

    MZ
    I think u need the oracle 9i DBA Administration guide.

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