ITPub博客

首页 > IT基础架构 > 网络安全 > Overview of the System Global Area (70)

Overview of the System Global Area (70)

原创 网络安全 作者:tsinglee 时间:2007-10-18 14:34:10 0 删除 编辑

A system global area (SGA) is a group of shared memory structures that contain data
and control information for one Oracle database instance. If multiple users are
concurrently connected to the same instance, then the data in the instance’s SGA is
shared among the users. Consequently, the SGA is sometimes called the shared global
area.
An SGA and Oracle processes constitute an Oracle instance. Oracle automatically
allocates memory for an SGA when you start an instance, and the operating system
reclaims the memory when you shut down the instance. Each instance has its own
SGA.

SGA
一组共享的包含数据和控制信息的内存结构 , Oracle实例由sga和Oracle进程组成 。
当实例启动时 ,Oracle自动分配内存 , 实例shutdown时 , 操作系统回收内存 。

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-977439/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1897991