Multiple choice technology databases

Which is the memory area that is created when a dedicated server process is started, and contains data and information for that server process?

  1. SGA

  2. Streams Pool

  3. PGA

  4. Shared Pool
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

PGA (Program Global Area) is a memory region created for each server process when it starts. It contains data and control information for that specific server process. SGA (System Global Area) is shared memory. Shared Pool and Streams Pool are components of the SGA, not per-process memory areas.

Keep practicing — related questions