Chapter 9. Performance Tuning
Performance tuning of any application, including the database, is an iterative process. This means that to maintain a healthy database, one must constantly monitor and fine-tune it. During certain periods, an aggressive performance tuning of both the application and database may be required. At other times, only routine continuous monitoring and maintenance may be needed. During this time, system hiccups may be discovered and solutions tried and tested.
The goal of a DBA or the application developer is to provide efficient, well-performing applications with good response time. In order for the application to provide a good response, the system, database, and SQL queries should be well tuned. Systems are tuned based ...
Get Oracle 10g RAC Grid, Services & Clustering now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
