The Ion for Oracle trend viewer
Oracle Tips by Burleson Consulting
There have been several third-party companies
developing graphical user interfaces to interface with STATSPACK data.
The premier product is Ion for Oracle.
Ion for Oracle allows Oracle
Remote DBAs to build graphical trend charts and generate alerts for more than
100 performance metrics for Oracle Server based on performance data
gathered by Oracle STATSPACK or AWR Utility and for custom statistics defined
by database administrator. The intent of Ion is to
provide a more convenient way to report and analyze performance
metrics gathered by STATSPACK and/or AWR.
The Ion Viewer allows you to see how
Oracle instance's performance metrics change with the course of time.
At a high level, the Ion for Oracle tool takes the performance data
stored in the Oracle STATSPACK tables and presents it as graphical
charts or trend reports. The Ion tool is also able to generate
alerts, store them in the database and notify a Remote DBA by e-mail service
if some performance metrics exceed alert thresholds set by the Oracle
|Tuning an Oracle database has been likened to working on a
car while it flies down the highway at 70 miles per hour.
Thousands of transactions are processed every second
and it’s extremely difficult to isolate and repair an Oracle
Oracle tuning takes years to master and the
internals of SQL optimization have become so complicated that only a
seasoned expert can make sense of Oracle tuning.
Ion for Oracle is a revolutionary new tool that
encapsulates the tuning techniques used by the world’s top Oracle
tuning experts. Using
applied artificial intelligence, Ion for Oracle employs decision
support system technology to relieve you of the tedium of querying
dozens of cryptic internal tables, placing the salient data right at
You can build STATSPACK charts both for
predefined set of statistics and for your own custom statistics. All
the predefined and custom statistics are grouped into categories, and
each of these can be plotted using the Ion GUI.
General Performance Statistics This
section includes general instance efficiency percentages.
Load Profile This section contains the
statistics, which describe the transactional workload on the
database system (logical and physical reads, writes, etc.).
System Wait Events This charts show a
Remote DBA what resources the system is waiting for.
SQL Reporting This section contains a
report that shows the most resource consuming SQL statements.
Activity Statistics This section
includes the charts, which describe the important database
instance’s statistics about rollback segments, latches and
particular user session activities.
Memory Statistics This chart provides a
performance picture of various SGA caches including buffer pools,
dictionary cache, and library cache.
I/O Statistics This section contains the
tablespace and datafile input/output characteristics.
Custom Charts This section unites all
the custom defined charts.
If you like Oracle tuning, you may enjoy the new book "Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts.
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today.