🎴 Flashcard Mode
Oracle Database Fundamentals
Card1 / 11
Mastered0
Review0
QuestionClick to flip
When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplish which two goals? (Choose two)
AnswerClick to flip back
A
To allocate memory to work areas in order to optimize both throughput and response time.
B
To ensure that the overall size of the PGA will never exceed the value of PGA_AGGREGATE_TARGET.
💡 Explanation:
When WORKAREA_SIZE_POLICY is set to AUTO, Oracle automatically allocates memory to work areas to optimize both throughput and response time, while ensuring total PGA memory stays within the PGA_AGGREGATE_TARGET limit.