053-417

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

　　 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 option 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.

 

OEM(OracleEnterpriseManager)