Chapter 9. Tuning Memory
In this chapter, we will cover:
- Tuning memory to avoid Operating System paging
- Tuning the Library Cache
- Tuning the Shared Pool
- Tuning the Program Global Area and the User Global Area
- 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 book, 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, ...
Get Oracle Database 11gR2 Performance Tuning Cookbook 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.
