Oracle Database Administration 2022 Certified Professional — Question 23

Which two statements are true about disabling Automatic Shared Memory Management (ASMM)? (Choose two.)

Answer options

• A. All auto-tuned SGA components are reset to their original user-defined values.
• B. All SGA components excluding fixed SGA and other internal allocations are readjusted immediately after disabling ASMM.
• C. Both SGA_TARGET and SGA_MAX_SIZE must be set to zero.
• D. All SGA components retain their current sizes at the time of disabling.
• E. The SGA size remains unaffected after disabling ASMM.
• F. It requires a database instance restart to take effect.

Correct answer: D, E

Explanation

The correct answers are D and E because when ASMM is disabled, the current sizes of the SGA components are preserved, and the overall SGA size does not change. Options A, B, C, and F are incorrect as they suggest that other SGA components are reset, adjusted, or require a restart, which does not happen when ASMM is disabled.