OCP-1Z0-052-V8.02-117题

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管理。