Oracle Database 12c: Installation and Administration — Question 110

Examine the following parameters for a database instance:

MEMORY_MAX_TARGET=0 -

MEMORY_TARGET=0 -

SGA_TARGET=0 -

PGA_AGGREGATE_TARGET=500m -
Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

Answer options

• A. LOG_BUFFER
• B. SORT_AREA_SIZE
• C. JAVA_POOL_SIZE
• D. STREAMS_POOL_SIZE
• E. DB_16K_CACHE_SZIE
• F. DB_KEEP_CACHE_SIZE

Correct answer: A, E, F

Explanation

The correct answers A, E, and F are parameters that are not controlled by ASMM, which focuses on managing the memory components within the SGA and PGA. Options B, C, and D are managed by ASMM, meaning they will adjust automatically based on workload requirements.