Q22. Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance?
- A. Sorts and Hash Joins use PGA memory.
- B. The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.
- C. The entire PGA is located in the System Global Area (SGA) when using shared servers.
- D. PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
- E. The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.
Xem thêm:
- Q143. Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection?
- Quản trị stored procedure trong Oracle Database
- Q5. Which three are true about recovery operations done without using Recovery Manager (RMAN)?
- Malware là gì?
- Q121. Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies?

Web mẫu - Dịch vụ vệ sinh Cleaning Services