CHAPTER 4

image

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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.