sga contains infomation (71)

The SGA is read/write. All users connected to a multiple-process database instance
can read information contained within the instance’s SGA, and several processes write
to the SGA during execution of Oracle.
The SGA contains the following data structures:
■ Database buffer cache
■ Redo log buffer
■ Shared pool
■ Java pool
■ Large pool (optional)
■ Streams pool
■ Data dictionary cache
■ Other miscellaneous information
Part of the SGA contains general information about the state of the database and the
instance, which the background processes need to access; this is called the fixed SGA.
No user data is stored here. The SGA also includes information communicated
between processes, such as locking information.
If the system uses shared server architecture, then the request and response queues
and some contents of the PGA are in the SGA.?

fixed SGA
sga中包含的資料庫和例項狀態的說明資訊 , 供後臺程式訪問

[@more@]