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

PGA_AGGREGATE_TARGET and WORKAREA_SIZE_POLICY work together: you must set a non-default value for PGA_AGGREGATE_TARGET before you can enable automatic PGA memory management by setting WORKAREA_SIZE_POLICY to AUTO. The target provides the upper bound that the automatic policy uses.

Keep practicing — related questions