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

Thread: SGA Size

  1. #1
    Join Date
    Jul 2002
    Posts
    205

    SGA Size

    SQL> sho sga

    Total System Global Area 135338868 bytes
    Fixed Size 453492 bytes
    Variable Size 109051904 bytes
    Database Buffers 25165824 bytes
    Redo Buffers 667648 bytes
    SQL>

    What is this Fixed Size and What is Variable Size...?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    fixed size is like a bootstrap area

    variable size = sum(bytes) v$sgastat

  3. #3
    Join Date
    Jul 2002
    Posts
    205
    Fixed Size and Variable Size, are they part of Shared Pool Size.. Or in other way what parameter in INIT.ORA makes up Fixed Size and Variable Size.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    variable is made up from shared pool size and the other parameters listed in v$sgastat

    fixed is well, fixed

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