1Z0-062 · Question #325
Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?
The correct answer is A. User Global Area. In shared server connections, the User Global Area (UGA) resides within the System Global Area (SGA) because server processes are shared among multiple client sessions.
Question
Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?
Options
- AUser Global Area
- BPrograms Global Area
- CSQL Query Result Cache
- DPL/SQL Function Result Cache
How the community answered
(22 responses)- A95% (21)
- B5% (1)
Why each option
In shared server connections, the User Global Area (UGA) resides within the System Global Area (SGA) because server processes are shared among multiple client sessions.
The User Global Area (UGA) holds session-specific data for a user, such as logon information and sort areas. In shared server configurations, the UGA for a client session is allocated within the SGA, specifically the large pool or shared pool, to allow shared server processes to access session state across different client requests.
The Programs Global Area (PGA) is private memory allocated to an Oracle server process and is always located outside the SGA, regardless of the connection type.
The SQL Query Result Cache is a component within the SGA's shared pool and is available for both dedicated and shared server connections, not exclusively for shared server.
The PL/SQL Function Result Cache is a component within the SGA's shared pool and is available for both dedicated and shared server connections, not exclusively for shared server.
Concept tested: Oracle memory structures and shared server architecture
Source: https://docs.oracle.com/en/database/oracle/oracle-database/23/concept/memory-architecture.html#GUID-DA00BB0B-3037-4348-AD29-B5DD252C53B3
Topics
Community Discussion
No community discussion yet for this question.