CHAPTER 4
Memory Structures
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). ...
Get Expert Oracle Database Architecture, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
