dbTrends for Oracle AWR and STATSPACK is an optimal cost-effective Oracle database performance monitoring and tuning solution for IT teams..
 

You are welcome to contact our technical support or sales teams to ask your questions. Software order phones are below:

US
+1 (952) 646 5747
+1 (800) 903 4152
Europe
+49 (221) 310 8820

dbTrends for Oracle AWR and STATSPACK

Introduction

dbTrends for Oracle AWR an STATSPACK product is our premier and most advanced software product for Oracle database performance tuning and monitoring based on performance data gathered by such Oracle tools as STATSPACK and Automatic Workload Repository (AWR). This unique software product is the next generation of our world-known and popular products as former Statspack Viewer and spViewer Enterprise. The dbTrends product provides cost-effective Oracle database monitoring and tuning solution based on free STATSPACK for companies which do not have very expensive 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 problem causes by comparing "good" and "bad" intervals of database operation. dbTrends is also ideal solution for Oracle consultancy companies which remotely manage customer Oracle databases and do not have direct access to customer 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 databases.

Why dbTrends is the Best Monitoring and Tuning Solution for Oracle Databases?

dbTrends is based on standard performance data gathered by standard Oracle database technologies such as STATSPACK and AWR. No additional agent software is required to be installed on database site 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 time interval to be 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 find root cause of performance issue like SGA memory problem, I/O datafile bottleneck, or SQL execution plan change, etc.

dbTrends is cost-effective solution for Oracle performance monitoring and tuning. dbTrends license cost is much cheaper comparing with license costs of Oracle tuning and diagnostic packs which require access to AWR data structures. Thus, the solution based on dbTrends and free STATSPACK is very cost-effective monitoring and tuning solution for Oracle databases.  dbTrends license cost is also much cheaper than license costs of other monitoring solutions for Oracle databases from third party vendors.

Furthermore, customers which purchase licenses for dbTrends will get also free of charge unlimited time technical support and software upgrade service.

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 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-mail lists.

dbTrends is an ideal solution for IT consultancies which are monitoring or tuning remote customers databases. Usually, IT consultancy does not have a direct access to customer production databases and only receives AWR or STATSPACK text performance reports. using dbTrends, IT consultancy can establish a repository for storing and analysis of customer performance reports. dbTrends is able to produce performance analysis, comparisons, and charts basing on collected performance reports from customers. Therefore, IT consultancy can quickly identify problem areas by comparing "good" and "bad" time intervals.

Our software team is very flexible and open for customers. We are always trying to implement good ideas from customers and fix software bugs as soon as possible.

 

Key Software Features

Now, Oracle professionals and database administrators can wield a complete solution to get most from Oracle AWR or STATSPACK performance data. All the dynamic visualization ability of dbTrends is now available for Oracle professionals, tuning experts, and database administrators. dbTrends is a complete solution for monitoring Oracle databases, providing:

Support of all current Oracle STATSPACK and AWR versions including 8.1.7, 9.0.1, 9.2.0, 10.1.0, 10.2.0, 11.1.0, 11.2.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.
An intuitive graphical user interfaces 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.
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.
Much more advanced features.
 

Software Requirements

Client operating systems: Windows 95/98/ME, Windows NT 4.0, Windows XP, Windows 2000/2003/2008, Windows Vista, Windows 7
Oracle database version: AWR - 10.1.0, 10.2.0, 11.1.0, 11.2.0, STATSPACK - 8.1.7, 9.0.1, 9.2.0, 10.1.0, 10.2.0, 11.1.0, 11.2.0
Oracle client software version: 8.1.7 or later
Oracle repository database version: 10.2.0 or later

Software 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 licenses in order to use it for 3 databases, you must purchase 3 licenses where every license cost is US$ 250. So, the total cost of 3 licenses will be 3 * 250 = US$ 750.

2010 © Copyright spViewer Software. All rights Reserved.