nerdexam
Oracle

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.

Exploring the Oracle Database Architecture

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)
  • A
    95% (21)
  • B
    5% (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.

AUser Global AreaCorrect

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.

BPrograms Global Area

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.

CSQL Query Result Cache

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.

DPL/SQL Function Result Cache

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

#System Global Area (SGA)#Shared Server#User Global Area (UGA)#Memory Architecture

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice