Multiple choice technology databases

In what way are the two initialization parameters PGA_AGGREGATE_TARGET and WORKAREA_SIZE_POLICY related to each other?

  1. The default value for PGA_AGGREGATE_TARGET depends on the setting of WORKAREA_SIZE_POLICY.

  2. You must provide a non-default value for PGA_AGGREGATE_TARGET before setting

  3. The value of PGA_AGGREGATE_TARGET can only be changed dynamically (that is, when the instance is

  4. You must not provide a non-default value for PGA_AGGREGATE_TARGET before setting
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle, setting WORKAREA_SIZE_POLICY to AUTO requires that PGA_AGGREGATE_TARGET is set to a non-zero value first, enabling automatic management of SQL work areas.

Keep practicing — related questions