If you want to use some different reports such as AWR; ASH etc. you may prefer to use the statspack report in Oracle Database.

STATSPACK is a performance diagnosis tool, available since Oracle8i. STATSPACK can be considered BSTAT/ESTAT’s successor, incorporating many new features. STATSPACK is a diagnosis tool for instance-wide performance problems; it also supports application tuning activities by providing data which identifies high-load SQL statements. STATSPACK can be used both proactively to monitor the changing load on a system, and also reactively to investigate a performance problem.

Here are some notes which you can get details about the Statspack report.

How to Identify Resource Intensive SQL for Tuning  Doc ID:232443.1
FAQ- Statspack Complete Reference  Doc ID:94224.1
TROUBLESHOOTING: Possible Causes of Poor SQL Performance    Doc ID:    33089.1

Installing and Configuring StatsPack Package [ID 149113.1]
FAQ- Statspack Complete Reference [ID 94224.1]
Creating a StatsPack performance report [ID 149124.1]
How To Understand AWR Report / Statspack Report [ID 842884.1]
What is StatsPack and where are the READMEs? [ID 149115.1]
Systemwide Tuning using STATSPACK Reports [ID 228913.1]
Oracle Applications and StatsPack [ID 153507.1]
Oracle9i Database Performance Tuning Guide and Reference-Using statspack
http://www.oracle-base.com/articles/8i/Statspack8i.php
How to Identify Resource Intensive SQL for Tuning  Doc ID:232443.1
TROUBLESHOOTING: Possible Causes of Poor SQL Performance Doc ID:33089.1

 

Advertisements