About WISE Enterprise Edition:
WISE is the premier
product for Oracle time-series tuning. With full version support, WISE
provides an intelligent interfaces to all STATSPACK Oracle10g Automated
Workload Repository (AWR) data.
contains intelligent utilities with an easy-to-use graphical interface allow
to Oracle professionals and Oracle tuning experts to see hidden trends and
copyrighted technology within WISE gives you unprecedented insight into more
than 100 Oracle performance statistics. WISE is designed
especially for large enterprise databases and provides a convenient
framework for managing and analyzing performance data of complex enterprise
Oracle database environments.
WISE Enterprise Edition Features
WISE supports all the
current versions of Oracle STATSPACK utility starting with 8.1.7 up to
Oracle10g release 10.1.0.
- Supports the
latest Oracle10g features as Automatic Workload Repository (AWR),
Automatic Database Diagnostic Monitor (ADDM), Active Session History
(ASH), and SQL Tuning Advisor.
- Support for
time-series wait-event tuning with ASH.
- Contains the WISE
Analyzer expert to produce hints and tips for STATSPACK data.
- Contains advanced
trend reports for AWR.
WISE is designed specifically for use by senior Oracle DBA
tuning professionals and is not suitable for beginners. Never make any
Oracle database changes unless you understand the potential ramifications
and have thoroughly tested the change.
Provides easy graphing and analysis for STATSPACK and AWR data.
Full Version Support
WISE works with any Oracle8i, Oracle9i or Oracle10g databases.
See hidden signatures of processing patterns for all Oracle metrics.
Displays time-series information on all important Oracle metrics and
makes expert recommendations.
WISE intelligent graphics can quickly locate I/O, CPU and Network
WISE has built-in advisor features to help you understand the root
cause of any Oracle performance issue.
By seeing regularly repeating changes in resource demand you can
easily alter Oracle to accommodate the changes.
WISE Enterprise is the
most advanced product in WISE products toolset. This unique product is
intended for large enterprises providing a convenient framework to manage and
analyze STATSPACK performance data of complex enterprise Oracle database
Now, Oracle professionals and
database administrators can wield a complete solution to get most from Oracle
STATSPACK utility. All the dynamic visualization ability of WISE Enterprise is
now available for Oracle professionals, tuning experts, and database
administrators. WISE Enterprise is a complete solution for monitoring
enterprise-level Oracle databases, providing:
of all current Oracle STATSPACK utility versions including 8.1.7, 9.0.1, 9.2.0,
proactive trend visualization.
hourly and daily changes.
support of performance statistics included in standard Oracle STATSPACK reports.
reports, statistics and any other information are managed from a single WISE
to store generated charts and STATSPACK reports analyses in a central database
STATSPACK data copying between different databases.
of STATSPACK data and reports using XML files or on-line.
to build charts for custom created statistics and store them in the WISE
of alert generation and DBA notification by e-mail service.
intuitive graphical user interfaces with fully customizable chart appearance.
chart reports are available for any STATSPACK performance metric.
to manage in GUI the Oracle STATSPACK data as taking the snapshots and cleaning
the old data.
of multiple simultaneous instance connections.
of creation central repository that stores STATSPACK performance data for all
to schedule chart reports for automatic execution and printing.
baseline feature support.
of reports generated by STATSPACK utility which highlights problem (bottleneck)
areas and provides intelligent hints and tips on performance tuning.
chart plotting functionality to generate trend charts by day hours, week days,
Automatic Workload Repository (AWR) support.
Automatic Database Diagnostic Monitor (ADDM) support.
Active Session History (ASH) support.
SQL Tuning Advisor support.
time chart reports for database metrics computed by Oracle10g database.
real-time performance chart reports.
more advanced features.
WISE Enterprise Is An Advanced
Charting Tool for STATSPACK
Oracle database administrators
(DBAs) and tuning experts can now build dynamic chart reports directly from
Oracle STATSPACK repository eliminating any manual data manipulation and report
chart reports directly from STATSPACK repository.
one click is needed to build a graph for any performance metric.
writing advanced chart reports which are based on STATSPACK repository tables.
to schedule any report for automatic execution and printing.
to establish a central STATSPACK repository to store and analyze performance
data at a single place.
scheduling chart reports for automatic generation and printing of chart reports.
events and DBA notification support.
Who Uses WISE Enterprise?
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. WISE Professional
product is best suited for medium-sized database environments. Junior-level
database administrators could benefit from a Standard version of WISE product.
WISE takes the performance data stored in the Oracle STATSPACK repository and
presents it as graphical charts or trend reports. Experienced DBAs know that
measuring performance data over time can provide great insights into hourly,
daily, and weekly "signatures". These signatures, in turn, tell an experienced
DBA when specific database tasks are stressing the database.
WISE 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.
WISE Enterprise supports such
latest Oracle10g 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:
statistics that determine both access and usage statistics of database segments.
model statistics based on time usage for activities, displayed in the
V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views.
of the system and session statistics collected in the V$SYSSTAT and V$SESSTAT
statements that are producing the highest load on the system, based on criteria
such as elapsed time and CPU time.
Session History (ASH) statistics, representing the history of recent sessions
WISE Enterprise provides you
with a set of pre-defined reports for AWR and allows you to build charts for any
statistic gathered by AWR the same way you do it for STATSPACK performance data.
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. WISE Enterprise allows you to work
simultaneously in heterogonous environment, which includes both STATSPACK
repositories of different versions from different databases and AWR databases.
The WISE Analyzer
utility supplied with WISE Enterprise highlights problem areas in database
performance and gives you intelligent hits and tips on tuning the database
instance. WISE Analyzer is a tool that provides analysis of report files
generated by Oracle STATSPACK utility. WISE Analyzer produces HTML report that
contains performance tuning tips and hints which are based on performance data
containing in STATSPACK text 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
STATSPACK report section and statistic as well as detailed hints and techniques,
which suggest multiple approaches to optimally tune Oracle instance
System - Windows 95/98/ME, Windows NT 4.0, Windows 2000, Windows XP,
can run ONLY on Windows NT 4.0, Windows 2000, and Windows 2003 operating
Client Software - 8.1.7 or later.
STATSPACK Utility Release 8.1.7, 9.0.1, 9.2.0,10.1.0, or 10.2.0
installed in the Oracle database. If you are running Oracle10g 10.1.0 or
later, you can have only Automatic Workload Repository in your database.
WISE Enterprise is able to work with only AWR repository without having
to install STATSPACK utility.
Server Release 8.1.7, 9.0.1, 9.2.0,10.1.0, or 10.2.0