Multiple choice

Which of the following statements is true when connecting to the Oracle instance using the multithreaded server configuration?

  1. The User Global Area (UGA) may only contain sort areas

  2. The UGA may be accessible to dedicated servers.

  3. The UGA components may reside in the large pool.

  4. The UGA components may reside in the buffer cache.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In multithreaded server (MTS) configuration, the User Global Area (UGA) is moved from the PGA to the large pool to enable memory sharing among multiple user processes. Dedicated servers store UGA in PGA, but MTS uses the large pool for efficient memory utilization.

Keep practicing — related questions