spViewer Enterprise

Build dynamic chart reports directly from Oracle STATSPACK repository
Download

spViewer Enterprise Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Shareware
  • Price:
  • $350.00
  • Publisher Name:
  • SpViewer Software
  • File Size:
  • 14.77M

spViewer Enterprise Tags


spViewer Enterprise Description

The Oracle STATSPACK utility is a set of scripts, which capture elapsed time statistics for over 100 performance metrics of Oracle instance and store the data in a special repository. Oracle STATSPACK utility generates a report file using performance data stored in the STATSPACK repository. Now, Oracle professionals and database administrators can wield a complete solution to get most from Oracle STATSPACK utility. All the dynamic visualization ability of SpViewer Enterprise is now available for Oracle professionals, tuning experts, and database administrators. SpViewer Enterprise is a complete solution that is designed for monitoring enterprise-level Oracle databases. This tool is intended for highly qualified Oracle tuning experts, senior-level database administrators, and teaching professionals. It is best suited for large enterprises with many Oracle databases, which are being monitored by STATSPACK. spViewer Enterprise allows you to get every morning the whole picture of your databases printed as charts reports or published on web site. You could manage all your databases STATSPACK environment from a single repository. spViewer Enterprise supports such latest Oracle features as Automatic Workload Repository and Oracle Automatic Database Diagnostic Monitor. The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database. The gathered data can be displayed in both reports and charts. The statistics collected and processed by AWR include: The difference of AWR from STATSPACK is that AWR is more automated and gathers a more advanced set of system and database statistics. The data gathered by AWR is also used by ADDM to produce intelligent recommendation reports. spViewer Enterprise allows you to work simultaneously in heterogonous environment, which includes both STATSPACK repositories of different versions from different databases and AWR databases. Note Before installation of SpViewer Enterprise you have to install Oracle Statspack Utility. Main features: Support of all current Oracle STATSPACK utility versions including 8.1.7, 9.0.1, 9.2.0, 10.1.0, 10.2.0, 11.1.0 Full support of performance statistics included in standard Oracle STATSPACK reports. All reports, statistics and any other information are managed from a single SpViewer Enterprise repository. Ability to store generated charts and STATSPACK reports analyses in a central repository. Automatic STATSPACK data copying between databases. Automatic old data removal from STATSPACK repository. Export/Import of STATSPACK data and reports using XML files. Ability to build charts for custom created statistics and store them in the database repository. Support of alert generation and DBA notification by e-mail service. An intuitive web graphical user interfaces with fully customizable chart appearances. Trend chart reports are available for any STATSPACK performance metric. Ability to manage in GUI the Oracle STATSPACK data as taking the snapshots and cleaning the old data. Support of multiple simultaneous instance and repository connections. Support of creation central repository that stores STATSPACK performance data for all enterprise databases. Ability to schedule chart reports for automatic execution and printing. Statistic baseline feature support. Analysis of reports generated by STATSPACK utility which highlights problem (bottleneck) areas and provides intelligent hints and tips on performance tuning. More than 100 real-time performance chart reports. Support of Oracle10g Automatic Workload Repository (AWR) feature 10.1.0, 10.2.0, 11.1.0 Support of Oracle10g Automatic Database Diagnostic Monitor (ADDM) feature. spReporter Utility included for batch performance report generation for STATSPACK and AWR.


spViewer Enterprise Related Software