Oracle
1Z0-083 · Question #149
Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance? (Choose two.)
The correct answer is D. Sorts and Hash Joins use PGA memory. E. The private SQL area (UGA) is located in the System Global Area (SGA) when using shared. https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/memory- architecture.html#GUID-913335DF-050A-479A-A653-68A064DCCA41
Oracle Database Architecture
Question
Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance? (Choose two.)
Options
- AThe private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated
- BPGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
- CThe entire PGA is located in the System Global Area (SGA) when using shared servers.
- DSorts and Hash Joins use PGA memory.
- EThe private SQL area (UGA) is located in the System Global Area (SGA) when using shared
How the community answered
(31 responses)- A13% (4)
- B6% (2)
- C6% (2)
- D74% (23)
Explanation
https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/memory- architecture.html#GUID-913335DF-050A-479A-A653-68A064DCCA41
Topics
#PGA#UGA#SGA#shared servers
Community Discussion
No community discussion yet for this question.