WORKAREA_SIZE_POLICY与自动PGA内…

最新推荐文章于 2021-12-02 23:23:45 发布

甲骨文可乐

最新推荐文章于 2021-12-02 23:23:45 发布

阅读量1.1k

点赞数

分类专栏：做程序员时积累的Oracle

本文链接：https://blog.csdn.net/u011316319/article/details/9276883

版权

做程序员时积累的Oracle 专栏收录该内容

154 篇文章 1 订阅

订阅专栏

文档地址：http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams227.htm#REFRN10231

WORKAREA_SIZE_POLICY

Property	Description
Parametertype	String
Syntax	`WORKAREA_SIZE_POLICY = { AUTO \| MANUAL }`
Defaultvalue	`AUTO`
Modifiable	`ALTERSESSION`, `ALTER SYSTEM`

WORKAREA_SIZE_POLICY specifies the policy forsizing work areas. This parameter controls the mode in whichworking areas are tuned.--设置这个参数WORKAREA_SIZE_POLICY为auto,manual的操作既可以在会话级别上完成，也可以在实例级别上完成。

Values:

AUTO

Work areas used by memory-intensive operators are sizedautomatically, based on the PGA memory used by the system, thetarget PGA memory set in PGA_AGGREGATE_TARGET, and therequirement of each individual operator.
MANUAL

The sizing of work areas is manual and based on the values ofthe *_AREA_SIZE parameter corresponding to theoperation (for example, a sort uses SORT_AREA_SIZE).Specifying MANUAL may result in sub-optimalperformance and poor PGA memory utilization.