spViewer Software

spAnalyzer for Oracle

spAnalyzer is a tool which provides intelligent analysis of text report files generated by Oracle Automatic Workload Repository (AWR) and STATSPACK engines. spAnalyzer produces HTML report that contains tuning tips and hints which are based on performance data contained in AWR or STATSPACK report. The resulting HTML report is split to several sections which are focused on particular areas of Oracle database instance performance tuning. This report includes detailed descriptions of each AWR or STATSPACK report section and statistic as well as detailed hints and techniques which contain suggestions to optimally tune Oracle instance. spAnalyzer is included to dbTrends package.

Software Requirements

Client operating systemsWindows 95/98/ME, Windows NT 4.0, Windows XP, Windows 2000/2003/2008/2012, Windows Vista, Windows 7, Windows 8, Windows 10 Oracle database versions
  • AWR 10.1.0, 10.2.0, 11.1.0, 11.2.0, 12.1.0, 12.2.0, 19.*
  • 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, 12.2.0, 19.*

Licensing Schema

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

Read More

Key Features

  • Supports analysis of Oracle AWR text reports versions 10.1.0, 10.2.0, 11.1.0, 11.2.0, 12.1.0, 12.2.0, 19.*
  • Supports analysis of Oracle STATSPACK text reports versions 8.1.7, 9.0.1, 9.2.0, 10.1.0, 10.2.0, 11.1.0, 11.2.0, 12.1.0, 12.2.0, 19.*
  • Detailed and intelligent analysis of major AWR or STATSPACK report sections
  • Provides advanced tuning tips and hints
  • Highlights problem areas and possible causes of performance bottlenecks.
  • Integration with dbTrends for Oracle product