nerdexam
Oracle

1Z0-063 · Question #98

Which parameter must be set to which value to implement automatic PGA memory management?

The correct answer is C. Set pga_aggregate_target to a nonzero value. See the full explanation below for the reasoning.

Question

Which parameter must be set to which value to implement automatic PGA memory management?

Options

  • ASet memory_target to zero.
  • BSet STATISTICS_LEVEL to BASIC.
  • CSet pga_aggregate_target to a nonzero value.
  • DSet pga_aggregate_target and sga_target to the same value.
  • ESet sgajtarget to zero.

How the community answered

(24 responses)
  • A
    4% (1)
  • B
    4% (1)
  • C
    83% (20)
  • E
    8% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice