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, and achieve the best performance from our hardware.

The first recipe covers some aspects related to the Operating System hosting our database.