Advertisement

Performance Tuning: Tuning the Instance

Abstract

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.

Keywords

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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Sam R. Alapati 2009

Personalised recommendations