supports ALL current Oracle STATSPACK utility versions including 8.0.*, 8.1.5,
8.1.6, 8.1.7, 9.0.1, 9.2.0, and 10.1.0. You can simultaneously view
performance data from different versions of Oracle STATSPACK utility.
support of performance statistics included in the standard Oracle STATSPACK
report. This implies that for all statistics displayed in the STATSPACK
standard report can be built as a trend chart.
to build charts for custom defined statistics and store them in database.
to build any number of detailed drilldown reports for any performance report.
to compare multiple relevant statistics in one chart window.
intuitive graphical user interfaces with fully customizable chart appearance.
to manage in GUI the Oracle STATSPACK data as taking the snapshots, analyzing
STATSPACK schema, and cleaning of old data.
of thin client. This option allows to WISE to work with Oracle directly
through TCP/IP protocol and doesn't require Oracle client software. To run
WISE it is only needed to have operation system and TCP/IP protocol support.
To connect to Oracle server from thin client you need know the address of
computer where Oracle server is, listening port number and database instance
of multiple simultaneous instances connections.
to build charts for any queries written by user.
to view and modify ALL the STATSPACK standard queries used to build chart
to store history data and build charts for historical data for any database
to generate automatically charts using WISE Service.
of alert definition for any statistic and automatic sending e-mail alert
notifications to any number of mail recipients.
customizable quick database health overview report.
to quickly copy any reports and its properties between databases. This feature
is very useful for Oracle DBAs managing multiple databases.
Service supports Oracle ALERT LOG file monitoring for unlimited number of
Oracle database instances.
report and statistic descriptions are available.
SQL Editor code completion feature that facilitates and speeds up SQL code
STATSPACK Parameters" function that enables Oracle DBA to setup STATSPACK
utility using a GUI interface and take a customized snapshot.
Execution Plan Usage" function for the "Top Resource SQL..." STATSPACK reports
allows you to view changes in the execution plan for the selected SQL
statement with the course of time. Note that this feature is only supported by
WISE Professional for STATSPACK 9.2.0 or later.
Execution Plan" feature for the "Top Resource SQL..." STATSPACK reports
enables you to generate visual execution plan tree for the selected SQL
to build trend charts for STATSPACK based reports. This feature allows Oracle
DBAs to build statistic trend charts for multiple snapshot ranges.
Furthermore, DBA can select days of week and hours of day to automatically
build statistics trend charts for the specified time periods.
Service allows to send an e-mail notification to DBA when connection to
database being monitored becomes unavailable.
to import any STATSPACK based statistic's chart into any another STATSPACK
based chart. This useful feature allows you to compare any STATSPACK
performance statisic to any other statistic on a single chart. Therefore, DBA
can easily find some correlation dependence between displayed performance
statistics. This "Chart Import" feature is available for STATSPACK based
charts as well as for STATSPACK trend charts.
to build all STATSPACK based report charts oi a single chart window. This
allows you to minimize memory amount used by the WISE Pro.
to copy STATSPACK performance data between databases (Supported STATSPACK
versions are 8.1.7, 9.0.1, and 9.2 ). This allows Oracle DBA to establish a
single centralized STATSPACK data repository for all databases and store all
STATSPACK data in this repository providing more convenient way of storing and
analyzing performance data.
to build graphs on a single chart for performance statistics which belong to
different databases loaded in a single STATSPACK repository. This feature
facilitates comparing performance behavior of multiple different databases.
Schedule feature allows Oracle DBA to schedule any STATSPACK based report for
automatic execution and printing. Note that The WISE Service should be started
to ensure this feature properly works.
statistic baseline support. This feature allows to Oracle DBAs to establish a
baseline for a given STATSPACK performance statistic and in future compare
current life of this statistic with its baseline.
time performance monitoring feature. WISE Professional provides more than 100
real time performance chart reports.
to create and modify custom real time performance chart reports.
based export / import support in order to facilitate quick and easy
propagation of real time monitor reports between different databases.
Response Time STATSPACK based reports allow you to estimate what part of the
total database response time is the most significant. Supported STATSPACK
versions are 8.1.7, 9.0.1, and 9.2.0
Professional now supports the ability to work with STATSPACK based chart
reports which belong to different instance connections and databases in a
single chart report window. This feature allows you to easily compare
performance trends of different databases on a single chart.
with WISE Analyzer to provide analysis
of report files generated by STATSPACK and produces performance tuning tips
and hints based on report data.
to work with STATSPACK data as another user account which is different from
STATSPACK owner account PERFSTAT. Note that this account must have all the
SELECT privileges and SYNONYMS for STATSPACK views and tables (note
that some views belong to SYS schema) as well as EXECUTE privilege for