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中包含的数据库和实例状态的说明信息 , 供后台进程访问
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-977451/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002869
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
