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

Thread: SGA Fixed Size

  1. 06-28-2002, 10:52 AM #1
    bensmail
    bensmail is offline Senior Member
    Join Date
    Mar 2002
    Posts
    303
    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
    Reply With Quote Reply With Quote
  2. 06-28-2002, 11:55 AM #2
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width