Advertisement

Performance Tuning: Tuning the Instance

  • Sam R. Alapati

Abstract

In the previous chapter, you learned how to tune an application by writing efficient SQL in order to maximize its performance. The use of optimal SQL, efficient design of the layout of the database objects, and so on are all part 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 Performance Tune Bind Variable Buffer Pool Archiver Process 
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 2003

Authors and Affiliations

  • Sam R. Alapati

There are no affiliations available

Personalised recommendations