Oracle Database 10g DBA Handbook

CHAPTER 8 Database Tuning

From a performance perspective, every system is designed to fail at some point. The goal of performance design is to make sure that the physical limitations of the applications—I/O throughput rates, memory sizes, query performance, and so on— do not impact the business performance. If the application performance limits the business process it is supposed to be supporting, the application must be tuned. During the design process, the limits of the application environment—including the hardware and the design of the application’s interactions with the database—must be evaluated. No environment provides infinite computing capacity, so every environment is designed to fail at some performance point. In the process of designing ...