Spotlight on Oracle 10.5 - Release Notes

Tune Your Oracle Database

The following is a summary of steps that you can undertake to tune Oracle by using Spotlight on Oracle.

Spotlight on Oracle supports an approach to Oracle performance tuning that could be described as "tuning by bottleneck". Spotlight on Oracle alerts you if any component of the Oracle architecture is forming a bottleneck. Additionally, Spotlight on Oracle provides tools that allow you to identify and rectify any inefficiency in your database’s configuration.

In general, you tune your Oracle instance by reiteratively identifying bottlenecks, contention, and critical resources, and by using the advice in this section to remove the bottleneck or contention or improve the performance of the resource.

In general, you tune your Oracle instance by reiteratively identifying bottlenecks, contention and critical resources, and by using Spotlight's online advice to remove the bottleneck or contention to improve the performance of the resource.

Notes:

• Spotlight on Oracle’s approach to Oracle instance-tuning is not the only valid approach. In particular, it emphasizes post-implementation tuning of Oracle applications, and remedial action to correct fundamental physical configuration deficiencies in an Oracle installation.
• Optimal database performance occurs when optimization is built into the application design and development process, and when the database’s physical design is specifically tailored to support an accurately estimated workload.