Multiple choice

Which memory area is not part of the SGA?

  1. Database Buffer Cache

  2. Redo log Buffer

  3. PGA

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

The SGA (System Global Area) is a shared memory region in Oracle that includes the Database Buffer Cache, Redo Log Buffer, and Shared Pool - all of which are accessible by multiple processes. PGA (Program Global Area) is private memory specific to each server process and is NOT part of the SGA. Each Oracle process has its own PGA containing session-specific variables and runtime areas.

Keep practicing — related questions