Which two are true about memory advisors? (Choose two.)

The correct answer is A. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor C. All memory advisors use data from Automatic Workload Repository. https://docs.oracle.com/database/121/ADMQS/GUID-8DE70F1D-E161-45D2-BE01- E9972883BCEC.htm#ADMQS1031

Monitoring and Tuning

Question

Options

AIf Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor
BIf Automatic Memory Management is enabled, no memory advisors are available.
CAll memory advisors use data from Automatic Workload Repository.
DIf Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer
EIf Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor

How the community answered

(35 responses)

A
71% (25)
B
9% (3)
D
17% (6)
E
3% (1)

Explanation

https://docs.oracle.com/database/121/ADMQS/GUID-8DE70F1D-E161-45D2-BE01- E9972883BCEC.htm#ADMQS1031

Topics

#memory advisors#AMM#ASMM#AWR data

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice