Oracle Database 12c: Installation and Administration — Question 180

Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?

Answer options

• A. User Global Area
• B. Program Global Area
• C. SQL Query Result Cache
• D. PL/SQL Function Result Cache

Correct answer: A

Explanation

The User Global Area (UGA) is specifically allocated in the SGA for shared server connections to manage session-specific data. The other options, such as the Program Global Area, SQL Query Result Cache, and PL/SQL Function Result Cache, are not limited to shared server connections and serve different purposes in the database instance.