Answer»
- To check whether tuning measures have the expected effect.
- To check the effects of changes in the configuration ( profile parameters, tablespace layout).
- To check whether a higher workload requires an adjustment of profile parameters.
- To obtain COMPARISON METRICS for the performance behavior before a scheduled change in the system (NEW platform, new storage, software upgrade, new Oracle release).
- To check system USER complaints about poor response times and to determine the causes for the poor performance.
- To recognize trends, that is, slow changes over a longer period, for example, an increasing workload, an increasing I/O load or an increasing CPU workload
- To determine load PEAKS, bottlenecks and their causes.
- To determine the SQL statements with the highest resource consumption (top SQL).
|
