spReporter is a tool which provides analysis of STATSPACK and Automatic Workload Repository AWR performance data and produces formatted HTML report with graphic charts included for selected performance statistics.

The utility is able to work in a batch mode or in an interactive GUI mode.

In GUI mode, spReporter provides you with convenient configuration wizard that allows you to customize reports and statistics to be included to the final report and charts.

Furthermore, spReporter utility allows you to generate comparison reports which allow you to compare two snapshot intervals at a glance.

Here are some key features of "spReporter":

· Full support of all STATSPACK and AWR standard reports and statistics.
· Ability to quickly build performance HTML reports with statistics charts for more than 100 statistics.
· Snapshot intervals comparison report mode.
· Ability to run in batch mode on a scheduled basis to produce daily performance reports.
· Ability to save reports configurations for future use in XML files.

Requirements:

· STATSPACK versions - 8.1.7, 9.0.1, 9.2.0, 10.1.0, 10.2.0, 11.1.0
· AWR versions - 10.1.0, 10.2.0, 11.1.0

Limitations:

· 30 days trial

What's New in This Release: [ read full changelog ]

· Added support of Oracle11g STATSPACK and AWR version 11.1.0.
· Added support for Oracle11g client.
· Top SQL reports fixed for AWR 10.2.
· Database Response time report is fixed for AWR 11.1.0