spViewer Software

spReporter for Oracle

spReporter is an inexpensive reporting tool which provides charting functionality for STATSPACK and Automatic Workload Repository (AWR) performance data and produces formatted HTML report with graphs included for selected performance statistics. spReporter can work in batch or 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. spReporter tool can be used by both Oracle database administrators and Oracle tuning experts and consultants to produce database performance health reports for management, tuning and capacity planning purposes. Also, Oracle DBAs and system administrators can use spReporter in batch mode to produce daily database performance reports and publish them at Web. spReporter is included to dbTrends package.

Software Requirements

Client operating systemsWindows 95/98/ME, Windows NT 4.0, Windows XP, Windows 2000/2003/2008, Windows Vista, Windows 7, Windows 8 Oracle database versions
  • AWR 10.1.0, 10.2.0, 11.1.0, 11.2.0, 12.1.0
  • STATSPACK 8.1.7, 9.0.1, 9.2.0, 10.1.0, 10.2.0, 11.1.0, 11.2.0, 12.1.0
Oracle client software versions32 bit version 8.1.7 or later.

Licensing Schema

spReporter tool is included to dbTrends for Oracle product package. That is, if you purchase licenses for dbTrends, you will get also license for spReporter free of charge. However, spReporter can be licensed as a standalone product without purchasing any other software licenses. spReporter is licensed by the number of databases (production, development, or test) it is used for. Read more below about software licensing options and prices available.

Read More

Key Features

  • Full support of all STATSPACK 8.1.7, 9.0.1, 9.2.0, 10.1.0, 10.2.0, 11.1.0, 11.2.0, 12.1.0 and AWR versions 10.1.0, 10.2.0, 11.1.0, 11.2.0, 12.1.0
  • Full support of all STATSPACK and AWR standard reports and statistics
  • All current version of STATSPACK and AWR are supported
  • 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
  • GUI configuration wizard support to customize report and charts content
  • Ability to save reports configurations for future use in XML files
  • Integration with dbTrends for Oracle product

Download