117. View the Exhibit and examine the initialization parameter settings.
Which three initialization parameters are to be set manually as they are not automatically tuned? (Choose
three.)
A.LOG_BUFFER
B.SORT_AREA_SIZE
C.JAVA_POOL_SIZE
D.STREAMS_POOL_SIZE
E.DB_16K_CACHE_SIZE
F.DB_KEEP_CACHE_SIZE
Answer: AEF
答案解析：
sys@TEST1023> select * from v$sgainfo
2 ;
NAME BYTES RES
-------------------------------- ---------- ---
Fixed SGA Size 2232960 No
Redo Buffers 16326656 No
Buffer Cache Size 1509949440 Yes
Shared Pool Size 436207616 Yes
Large Pool Size 16777216 Yes
Java Pool Size 16777216 Yes
Streams Pool Size 0 Yes
Shared IO Pool Size 0 Yes
Granule Size 16777216 No
Maximum SGA Size 3340451840 No
Startup overhead in Shared Pool 115126096 No
Free SGA Memory Available 1342177280
12 rows selected.
sys@TEST1023> desc v$sgainfo
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
NAME VARCHAR2(32)
BYTES NUMBER
RESIZEABLE VARCHAR2(3)
RESIZEABLE 为YES的在AMM或者ASMM的时候就会自动调整池的大小，为NO的就只能手动调整。
图中sga_target设置有值，故是ASMM管理。