OCP-1Z0-053-V12.02-66题

 

66.Which two initialization parameters would you set to enable Automatic Shared Memory Management?

(Choose two.)

A. set SHARED_POOL_SIZE to zero

B. set STATISTICS_LEVEL to BASIC

C. set SGA_TARGET to a non-zero value

D. set DB_CACHE_SIZE to a non-zero value

E. set STATISTICS_LEVEL to TYPICAL or ALL

Answer: AC

答案解析：

参考： http://blog.csdn.net/rlhua/article/details/12493791

启用ASMM 的具体过程取决于是从手动共享内存管理模式更改为 ASMM，还是从自动内存管理模式更改为ASMM。要从手动共享内存管理模式更改为 ASMM，执行以下操作：

1. 运行以下查询获取SGA_TARGET的值：

SELECT ((SELECT SUM(value) FROM V$SGA) - (SELECT CURRENT_SIZE FROM

V$SGA_DYNAMIC_FREE_MEMORY)) “SGA_TARGET” FROM DUAL;

 

2. 设置SGA_TARGET的值：

ALTER SYSTEM SET SGA_TARGET= value [SCOPE={SPFILE|MEMORY|BOTH}]

其中value是在步骤1  中计算的值，或者是介于所有SGA 组件的总大小与SGA_MAX_SIZE之间的某个值。

 

3. 将自动设置大小的SGA 组件的值设置为0。为此，需要编辑文本初始化参数文件，或者发出ALTER SYSTEM语句。如果需要，重新启动实例。

SGA组件：

sys@TEST0924> select * from v$sgainfo;

 

NAME                                  BYTES RES

-------------------------------- ---------- ---

Fixed SGA Size                      2232960 No

Redo Buffers                       16326656 No

Buffer Cache Size                1795162112 Yes

Shared Pool Size                  637534208 Yes

Large Pool Size                    16777216 Yes

Java Pool Size                     16777216 Yes

Streams Pool Size                  16777216 Yes

Shared IO Pool Size                       0 Yes

Granule Size                       16777216 No

Maximum SGA Size                 3340451840 No

Startup overhead in Shared Pool   117967168 No

Free SGA Memory Available         838860800

 

12 rows selected.