ITPub博客

首页 > 数据库 > Oracle > Memory Architecture Overview

Memory Architecture Overview

翻译 Oracle 作者:wanghanjun 时间:2015-12-29 11:05:26 0 删除 编辑
link:http://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN11198

The basic memory structures associated with Oracle Database include:
最基本的内存结构如下                    
  • System Global Area (SGA) 系统全局区

    The SGA is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA is shared by all server and background processes. Examples of data stored in the SGA include cached data blocks and shared SQL areas.
    SGA是一组共享内存的集合.作为SGA的组件,包含一个数据库实例的数据和控制信息.SGA被所有的服务器进程和后台进程共享.在SGA存储的数据包含已经缓存的数据库和共享SQL区域

  • Program Global Area (PGA)
    程序全局区             

    A PGA is a memory region that contains data and control information for a server process. It is nonshared memory created by Oracle Database when a server process is started. Access to the PGA is exclusive to the server process. There is one PGA for each server process. Background processes also allocate their own PGAs. The total PGA memory allocated for all background and server processes attached to an Oracle Database instance is referred to as the total instance PGA memory, and the collection of all individual PGAs is referred to as the total instance PGA, or just instance PGA.
    PGA是一个包含某一个服务器进程的数据和控制信息的内存区域.是一个非共享的内存区域当服务器进程启动的时候.PGA只能被一个服务器进程访问.没一个服务器进程都有一个PGA.后台进程也会有他们自己的PGA.全部PGA的区域包含后台和服务器进程是由PGA  Memmory来决定的.所有PGA的集合是 实例PGA,

Figure 6-1 illustrates the relationships among these memory structures.

De.ion of Figure 6-1 follows

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

请登录后发表评论 登录
全部评论

注册时间:2014-05-28

  • 博文量
    42
  • 访问量
    33798