首页 > 应用开发 > IT综合 > sga contains infomation (71)

sga contains infomation (71)

原创 IT综合 作者:tsinglee 时间:2007-10-18 16:16:30 0 删除 编辑

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博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
  • 博文量
  • 访问量