The two main sections of memory for the Oracle instance are the System Global Area (SGA)and the ____.
A) Queue Monitor Area (QMA)
B) Job Queue Area (JQA)
C) Dispatcher Global Area (DGA)
D) Program Global Area (PGA)

Question

Quizplus · Accepted Answer

The Program Global Area (PGA) is the memory area that holds information about a single user process or session. It contains information such as the user's session variables and private SQL area. The SGA holds information for the entire Oracle instance, while the PGA holds information for each individual user process. The other options listed (QMA, JQA, and DGA) are not valid memory sections in an Oracle instance.

The Two Main Sections of Memory for the Oracle Instance