052-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

从下我们可以知道哪些组件是可以自动调整的
SQL> 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



 

posted @ 2017-12-12 15:49  巴啦啦大魔王  阅读(146)  评论(0编辑  收藏  举报