Databases Reference
In-Depth Information
9
Tuning Memory
In this chapter, we will cover:
F
Tuning memory to avoid Operating System paging
F
Tuning the Library Cache
F
Tuning the Shared Pool
F
Tuning the Program Global Area and the User Global Area
F
Tuning the Buffer Cache
Introduction
So far we have introduced various aspects of Oracle database performance tuning, mostly
related to the application code and storage structures.
The last three chapters of this topic, starting with this one, will focus on the tuning aspects
related to the hardware environment and to the internal structure of the Oracle database,
starting with memory tuning in this chapter.
We will see which structures are stored in the memory by the database and how to configure
them to use the physical memory available optimally, and achieve the best performance from
our hardware.
The first recipe covers some aspects related to the Operating System hosting our database.
