首页 > 应用开发 > IT综合 > PGA Memory Management for Dedicated Mode (102)

PGA Memory Management for Dedicated Mode (102)

原创 IT综合 作者:tsinglee 时间:2007-10-26 11:16:36 0 删除 编辑
You can automatically and globally manage the size of SQL work areas. The database
administrator simply needs to specify the total size dedicated to PGA memory for the
Oracle instance by setting the initialization parameter PGA_AGGREGATE_TARGET. The
specified number (for example, 2G) is a global target for the Oracle instance, and
Oracle tries to ensure that the total amount of PGA memory allocated across all
database server processes never exceeds this target.
With PGA_AGGREGATE_TARGET, sizing of work areas for all dedicated sessions is
automatic and all *_AREA_SIZE parameters are ignored for these sessions. At any
given time, the total amount of PGA memory available to active work areas on the
instance is automatically derived from the parameter PGA_AGGREGATE_TARGET. This
amount is set to the value of PGA_AGGREGATE_TARGET minus the PGA memory
allocated by other components of the system (for example, PGA memory allocated by
sessions). The resulting PGA memory is then allotted to individual active work areas
based on their specific memory requirement.
对于活动的工作区来说 , 可用的pga内存是PGA_AGGREGATE_TARGET指定的值减去pga为其他系统组件分配的内存[@more@]

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: SQL Work Areas(101)
请登录后发表评论 登录
  • 博文量
  • 访问量