Performance Tuning: Tuning the Instance
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.
KeywordsExecution Plan Performance Tune Bind Variable Buffer Pool Archiver Process
Unable to display preview. Download preview PDF.