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. When automatic memory management is not enabled, the default method for the instance PGA is automatic PGA memory management.

New Features for Performance

Question

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

(46 responses)

A
13% (6)
B
4% (2)
C
78% (36)
D
2% (1)
E
2% (1)

Explanation

When automatic memory management is not enabled, the default method for the instance PGA is automatic PGA memory management.

Topics

#PGA memory management#pga_aggregate_target#automatic memory management

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice