spViewer Software

dbTrends for Oracle

dbTrends for Oracle AWR and STATSPACK product is our innovative and very popular software product for Oracle database performance tuning and monitoring based on performance data gathered by Oracle engines as STATSPACK and Automatic Workload Repository (AWR). This unique software is the next generation of our world-known and popular products as former Statspack Viewer Enterprise. The dbTrends product based on STATSPACK provides cost-effective database monitoring and tuning solution for companies which do not have very expensive Oracle tuning and diagnostic packs licenses required to access AWR. dbTrends is also powerful solution for large enterprises to monitor and tune many Oracle databases from a single point using advanced AWR performance data. dbTrends provides much more insights into AWR and STATSPACK performance data comparing with standard Oracle Enterprise Manager or third party vendors and allows to quickly identify performance trends and issues by comparing "good" and "bad" intervals of database operation. dbTrends is an ideal software tool for Oracle consultaning companies which manage remote customers' databases. dbTrends provides unique functionality to compare and analyze standard text performance reports generated by Oracle AWR and STATSPACK tools. In this case, dbTrends monitors and tunes database performance using text STATSPACK and AWR reports provided by remote customers. This feature is extremely useful when you monitor and tune remote databases to which you do not have direct access. This situation is very common for IT consulting companies which remotely consult and tune customer's databases.

The latest dbTrends release 1.3 introduces a new great SQL performance and trend analysis capability based on new SQL profiles feature. SQL profiles are named sets of SQL statements running on your Oracle databases. You are able to define SQL profiles based on various criteria of your Oracle applications like schema names, database objects patterns, application modules and action names. Using this unique SQL monitoring feature, Oracle database administrators are able to continuously monitor SQL performance and response time of critical business applications. By generating trend reports and charts for SQL profiles, Oracle DBAs can quickly assess the overall application performance and application/database response times and identify causes of application performance issues.

Why dbTrends?

  • dbTrends is based on performance data gathered by standard Oracle database engines as STATSPACK and AWR. No additional agent software is required on your database for monitoring. No additional overhead is placed on production databases being monitored.
  • dbTrends uses the following approach to monitor and tune Oracle databases performance: you can easily and quickly compare two different time intervals of database operation: baseline and comparison. Typically, baseline represents time interval when database operation had good response time and performance. When your database experiences some performance degradation, you choose this bad interval as comparison time interval and compare it with good baseline. By comparing baseline and comparison time intervals, you can quickly identify what performance statistics and areas influence this performance degradation. After you have this information, you can quickly find root cause of performance issues like SGA memory problem, I/O datafile bottleneck, SQL execution plan change, etc.
  • dbTrends is cost-effective solution for Oracle database monitoring and tuning. dbTrends license cost is much cheaper comparing with license costs of Oracle tuning and diagnostic packs and third party vendors which require access to AWR data structures. Therefore, dbTrends and free STATSPACK provide very cost-effective and complete monitoring solution for Oracle databases.
  • Registered customers are eligible for free of charge technical support and software upgrade service. No maintenance and additional fees are required.
  • dbTrends provides much more insights and analysis of AWR or STATSPACK performance data comparing with standard functionality available in Oracle Enterprise Manager or third party solutions.
  • dbTrends is a best solution for day-to-day Oracle database monitoring, tuning and performance analysis and reporting for large enterprises. Oracle database administrators are able from a single console monitor and compare performance with baselines for many production databases. dbTrends can also automate performance reports generation for management and publishing it on Web or sending to e-mails.

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 client version from 8.1.7 up to 12.1.0 Oracle database version for dbTrends repository10.2.0 or later

Licensing Schema

dbTrends is licensed by the number of Oracle databases (production, development, or test) for which the software is used. For example, if you want to purchase dbTrends license to monitor 3 databases, you must purchase 3 licenses where every license cost is US$ 330. So, the total cost of 3 licenses will be 3 * 330 = US$ 990.

Read More

Key Features

  • Support of all current Oracle 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 performance statistics included in standard Oracle STATSPACK and AWR reports
  • All reports, statistics and any other information are managed from a single repository
  • Ability to store customer AWR or STATSPACK reports in a central repository for future analysis and charting
  • Ability to create and build charts for custom created statistics
  • Intelligent caching technology for reports and generated charts to improve charts processing performance
  • An intuitive GUI with fully customizable chart appearance
  • Easy comparison of baseline and selected time intervals for quick problem detection
  • Ability to manage in GUI the Oracle STATSPACK and AWR data as taking the snapshots and cleaning the old data
  • Support of multiple simultaneous instance connections
  • Support of creation central repository that stores STATSPACK and AWR performance data for all enterprise databases
  • Ability to schedule reports for automatic execution, storing in web archive format and sending to specified e-mails
  • Statistic baseline feature support
  • SQL application performance monitoring, trend and tuning based on SQL profiles feature
  • Analysis of reports generated by AWR and STATSPACK tools which highlights problem (bottleneck) areas and provides intelligent hints and tips on performance tuning
  • Oracle Automatic Database Diagnostic Monitor (ADDM) support
  • Ability to build comparisons and charts for text AWR or STATSPACK performance reports received from remote Oracle databases
  • High performance of reports and charts generations for large amounts of performance data
  • More than 100 performance reports and statistics
  • spAnalyzer and spReporter are included to dbTrends package and do not require additional licensing

Download