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 allocates memory to work areas to optimize both throughput and response time, while ensuring total PGA memory stays within the PGA_AGGREGATE_TARGET limit.

Keep practicing — related questions