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

Thread: SGA Fixed Size

Hybrid View

  1. #1
    Join Date
    Mar 2002
    Posts
    301
    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
    Location
    Washington DC
    Posts
    1,843
    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
    http://metalink.oracle.com/metalink/...p_id=1008866.6
    Reddy,Sam

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