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
Seems that exhibit doesn’t match the question. Or am I wrong?
You’re wrong, I’m afraid – each answer is potentially autotuned based on memory target parameters.
B. The sort_area_size is ignored when pga_aggregate_target is set, as it is above. So this would be auto tuned.
C. The SHARED_POOL_SIZE, LARGE_POOL_SIZE, JAVA_POOL_SIZE, STREAMS_POOL_SIZE and DB_CACHE_SIZE are all set automatically if SGA_TARGET is set. It is, so this would be autotuned.
D. As C
Why the answers listed are correct:
A. LOG_BUFFER is never autotuned, it requires a DB bounce to implement a change
E. DB_16K_CACHE_SIZE means you’re explicitely allowing using of 16k block size. Not a default and not autotunable.
F. You need to be proactive about defining DB_KEEP_CACHE_SIZE, based on what you’re actually putting in there. Not autotunable.
very good!