Choose two. Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance?
The entire PGA is located in the System Global Area (SGA) when using shared servers.
PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.
The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.
Sorts and Hash Joins use PGA memory.
Submit