Multiple choice technology programming languages

Which component 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

PGA (Program Global Area) contains session-specific memory like variables and arrays when NOT running in MTS (Multi-Threaded Server) mode. In dedicated server mode (non-MTS), each session gets its own PGA. SGA is shared instance memory, SQL Area and Library Cache are components of Shared Pool within SGA - all are shared, not per-session.

Keep practicing — related questions