Advertisement

Memory Structures

Abstract

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

Keywords

Memory Management Memory Structure Memory Allocation Query Plan Shared Server 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Thomas Kyte 2010

Personalised recommendations