Oracle Database Administration II — Question 181

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

Answer options

• A. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
• B. If Automatic Memory Management is enabled, no memory advisors are available.
• C. All memory advisors use data from Automatic Workload Repository.
• D. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
• E. If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.

Correct answer: A, B

Explanation

Option A is correct because with Automatic Shared Memory Management, both the SGA and PGA Advisors are indeed available. Option B is also correct as Automatic Memory Management disables all memory advisors, which is contrary to what the other options state. The other options contain incorrect statements regarding the availability and functionality of memory advisors under different memory management configurations.