Which two statements are true about disabling Automatic Shared Memory Management (ASMM)?
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.
The Answer Is:
D, E
This question includes an explanation.
Explanation:
When ASMM is disabled, the sizes of the automatically managed SGA components remain at their current values. ASMM is controlled by the SGA_TARGET parameter. If SGA_TARGET is set to a non-zero value, ASMM is enabled and Oracle will automatically manage the sizes of the various SGA components. When ASMM is disabled, by setting SGA_TARGET to zero, the SGA components that were automatically sized will retain their current sizes rather than being reset to their original user-defined values. The overall size of the SGA remains the same unless manually changed by modifying individual component sizes or SGA_MAX_SIZE.
References:
Oracle Database Administration Guide, 19c
Oracle Database Performance Tuning Guide, 19c
1z0-084 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"