Which three initialization parameters are to be set manually as they are not automatically tuned?

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.)

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



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Roman Malyuta

Roman Malyuta

Seems that exhibit doesn’t match the question. Or am I wrong?

Ken Savage

Ken Savage

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.

Levijr

Levijr

very good!