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

Thread: SGA Fixed Size

  1. #1
    Join Date
    Mar 2002
    What's mean here Fixed size of SGA??
    I always thought PGA is a fixed size of SGA, but my sort_area_size=1M und Fixed size=0,75M!!
    Can someone explain me?

    SQL> startup force
    Instance ORACLE lanc┌e.

    Total System Global Area 61216796 bytes
    Fixed Size 75804 bytes
    Variable Size 18919424 bytes
    Database Buffers 42143744 bytes
    Redo Buffers 77824 bytes

  2. #2
    Join Date
    Feb 2000
    Washington DC
    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.

    For further reading

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.