oracle官方文档之Memory Architecture之Shared SQL Areas and Private SQL Areas

最新推荐文章于 2022-01-23 10:51:07 发布

haiross

最新推荐文章于 2022-01-23 10:51:07 发布

阅读量949

点赞数

分类专栏： oracle体系架构

本文链接：https://blog.csdn.net/haiross/article/details/19077859

版权

Oracle的共享池包含图书馆缓存、字典缓存和控制结构等。共享SQL区域对所有用户可见，存储解析树和执行计划。每个SQL语句由一个共享SQL区和一个私有SQL区表示，Oracle通过重用共享SQL区节省内存。PL/SQL程序单元的处理方式类似，分配共享和私有区域存储编译形式和会话特定值。

摘要由CSDN通过智能技术生成

Shared Pool

The shared pool portion of the SGA contains the library cache, the dictionary cache, buffers for parallel execution messages, and control structures.

The total size of the shared pool is determined by the initialization parameterSHARED_POOL_SIZE. The default value of this parameter is 8MB on 32-bit platforms and 64MB on 64-bit platforms. Increasing the value of this parameter increases the amount of memory reserved for the shared pool.

Library Cache

The library cache includes the shared SQL areas, private SQL areas (in the case of a shared server configuration), PL/SQL procedures and packages, and control structures such as locks and library cache handles.

Shared SQL areas are accessible to all users, so the library cache is contained in the shared pool within the SGA.

因为Shared SQL areas要被所有用户访问，所以包含了Shared SQL areas的library cache要位于SGA上的shared pool中。

注释：

Memory Area	Dedicated Server	Shared Server
Nature of session memory	Private	Shared
Location of the persistent area	PGA	SGA
Location of part of the run-time area for `SELECT` statements	PGA	PGA
Location of the run-time area for DML/DDL statements	PGA	PGA

参考上述来自oracle11gR2官方文档里的表格（http://docs.oracle.com/cd/B19306_01/server.102/b14220/memory.htm#i14490），可知这里说的共享服务器模式时共享服务器进程的private SQL areas应该是部分在Library Cache上。