Multiple choice

Which of the following components of an instance holds session variables and arrays when you are NOT running in MTS mode?

  1. SGA

  2. SQL Area

  3. Library Cache

  4. PGA

  5. Shared Pool
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The PGA (Program Global Area) is a memory region that stores session-specific information and variables for each user session when NOT running in MTS (Multi-Threaded Server) mode. It contains private SQL areas, session variables, and other session-specific data structures. The SGA is shared across all sessions, while the PGA is exclusive to each session.

Keep practicing — related questions