ocp-318

QUESTION NO: 318
When manually configuring the SGA, which of the following parameter changes requires an instance
restart to take effect?
A. DB_CACHE_SIZE
B. SHARED_POOL_SIZE
C. LARGE_POOL_SIZE
D. JAVA_POOL_SIZE
E. SGA_MAX_SIZE
F. SORT_AREA_SIZE
Answer: E
The SGA_MAX_SIZE parameter can be changed in the spfile using OEM, but it cannot be changed
dynamically for the instance. It requires an instance restart to take effect. You can change options A, B, C,
and D without requiring a restart as long as the sum of the values remains less than the value for
SGA_MAX_SIZE. SORT_AREA_SIZE is not an SGA parameter.

当手动配置系统全局区，以下哪一个参数变化需要重新启动一个实例以生效？

E.系统全局区最大尺寸

使用OEM的spfile的SGA的最大尺寸参数可以改变，但它不可以被动态改变用于实例。它需要一个实例重启才能生效。您可以更改选项A, B, C和 D
而不需要重新启动作为只要值的总和仍然小于SGA最大尺寸的值。 排序区域的大小不是SGA参数。