Performance Tuning: Tuning the Instance


In the previous chapter, you learned how to write efficient SQL to maximize an application’ performance. The use of optimal SQL and efficient design of the layout of the database objects are parts of a planned or proactive tuning effort. This chapter focuses on the efficient use of the resources Oracle works with: memory, CPU, and storage disks.


Execution Plan Bind Variable Buffer Pool Archiver Process Total Wait Time 
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.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Sam R. Alapati 2009

Personalised recommendations