Question

Tuning : When to Tune ?

Answer 1

There are two distinct types of Tuning :

â–  Proactive Monitoring
â–  Bottleneck Elimination

Proactive monitoring can also be considered as proactive tuning. Proactive monitoring usually occurs on a regularly scheduled interval, where a number of performance statistics are examined to identify whether the system behavior and resource usage has changed.

Bottleneck Elimination : In general, performance problems are caused by the over-use of a particular resource. That resource is the bottleneck in the system. There are a number of distinct phases in identifying the bottleneck and the potential fixes. These are discussed in the sections that follow. Remember that the different forms of contention are symptoms that can be fixed by making changes in the following places:

â–  Changes in the application, or the way the application is used
â–  Changes in Oracle
â–  Changes in the host hardware configuration