Multiple choice technology databases

When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplish which two goals? (Choose two)

  1. To tune memory using the existing *_AREA_SIZE parameters.

  2. To allocate memory to work areas in order to optimize throughput only.

  3. To allocate memory to work areas in order to optimize response time only.

  4. To allocate memory to work areas in order to optimize both throughput and response time.

  5. To ensure that the overall size of the PGA will never exceed the value of PGA_AGGREGATE_TARGET.
Reveal answer Fill a bubble to check yourself
D,E Correct answer
Explanation

When WORKAREA_SIZE_POLICY is set to AUTO, Oracle automatically manages PGA memory allocation. The policy aims to optimize both throughput (overall processing volume) and response time (individual query speed), while ensuring the total PGA memory stays within the PGA_AGGREGATE_TARGET limit.

Keep practicing — related questions