ocp-321

QUESTION NO: 321
Automatic PGA Memory Management eliminates the need to manually configure which of the following
initialization parameters? (Choose all that apply.)
A. SORT_AREA_SIZE
B. HASH_AREA_SIZE
C. BITMAP_MERGE_AREA_SIZE
D. CREATE_BITMAP_AREA_SIZE
E. PGA_AGGREGATE_TARGET
Answer: A,B,C,D
Each of these are work areas in the PGA is configured manually if Automatic PGA Memory Management
is not enabled. You enable Automatic PGA Memory Management when you disable Automatic Memory
Management and set a nonzero value for the PGA_AGGREGATE_TARGET parameter.

---

自动程序全局区内存管理省去手动配置以下哪些初始化参数？

A.排序区域大小
B.散列区大小
C.位图合并区域大小
D.创建位图区域的大小

Answer: A,B,C,D

这些都是在PGA工作区手动配置如果未启用自动PGA内存管理。 当你禁用了自动内存管理， 启用自动PGA内存管理， 并
PGA集合目标参数设置为非零值。

---