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

Hybrid View

  1. #1
    Join Date
    Sep 2000

    Red face

    What is the Fixed Size and the variable Size in the output when you give the show sga command.

    SQL> show sga

    Total System Global Area 217520156 bytes
    Fixed Size 75804 bytes
    Variable Size 79519744 bytes
    Database Buffers 137846784 bytes
    Redo Buffers 77824 bytes


  2. #2
    Join Date
    Oct 2000
    Saskatoon, SK, Canada

    Different sub-divisions of the SGA

    Sample from svrmgrl SHOW SGA:

    Total System Global Area 23460696 bytes
    Fixed Size 72536 bytes
    Variable Size 22900736 bytes
    Database Buffers 409600 bytes
    Redo Buffers 77824 bytes

    Total System Global Area
    -Total in bytes of all the sub-divisions that makes up the SGA.

    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
    See 'Approximationg size of the SGA' section for version specific information.

    Database Buffers
    -Holds copies of data blocks read from datafiles.
    size = db_block_buffers * block size

    Redo Buffers
    -A circular buffer in the SGA that holds information about changes made to
    the database. Enforced mininum is set to 4 times the maximum database block
    size for the host operating system.


    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.