System Global Area (SGA): This is a large, shared memory segment that virtually all Oracle processes will access at one point or another.
Process Global Area (PGA): This is memory that is private to a single process or thread; it is not accessible from other processes/threads.
User Global Area (UGA): This is memory associated with your session. It is located either in the SGA or the PGA, depending whether you are connected to the database using a shared server (it will be in the SGA), or a dedicated server (it will be in the PGA).
KeywordsMemory Management Memory Structure Memory Allocation Query Plan Shared Server
Unable to display preview. Download preview PDF.