In this chapter, we’ll look at Oracle’s three major memory structures:
System Global Area (SGA): This is a large, shared memory segment that virtually all Oracle processes will access at one point or another.
Process (or Program) 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 ...
