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 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). ...