Choose two.
Which two are true about the Program Global Area (PGA.and its management in an
Oracle database instance?
A.The entire PGA is located in the System Global Area (SGA.when using shared正确答案DE
Servers. B.PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session. C.The private SQL area (UGA.is located in the System Global Area (SGA.when
Using dedicated servers. D.The private SQL area (UGA.is located in the System Global Area (SGA.when
Using shared servers. E.Sorts and Hash Joins use PGA memory.