Ion is the only
comprehensive Oracle time-series tuning tool. Ion allows you to
quickly spot hidden performance bottlenecks and get right to the heart of
any Oracle tuning problem.
Ion works with both
the free Oracle STATSPACK utility and the licenced AWR utility
to bring you time-series workload insights. Here are just a few reasons why Ion is a great
supplement to the Oracle Enterprise Manager:
Database Diagnostic Pack and Oracle Performance Packs are a $6,000 extra-cost
licensing option, and you must have a
license to access the Oracle10g AWR tables. This includes
AWR (Automatic Workload Repository), the dbms_workload_repository package,
the awrrpt.sql and awrrpti.sql reports, any of the dba_hist and
v$active_session_history views, ADDM - Automatic Database Diagnostic
Monitor, and all dba_advisor views.
has many of these features and uses can use the free STATSPACK
utility if AWR is not an option.
Even the most experienced Oracle
tuning expert needs to be able to visualize changes over time periods.
Proponents of time-series Oracle tuning understand that Oracle is constantly
changing and you must tune the database based on repeating loads. With
this tool, you can quickly learn if different snapshot value are statistically
Ion is the first
performance tuning tool for Oracle AWR and STATSPACK that allows you to
easily build time-series trend charts for almost all statistics available in
Ion allows you to compare average
values by day-of-the-week and hour-of-the-day, quickly enabling you to find
hidden performance bottlenecks and repeating changes to Oracle database
load. Ion allows you to aggregate any of more than
100 performance metrics (from either Oracle10g AWR or STATSPACK) and
visualize the signature. Signatures are very common in Oracle
databases because of the habits of the end-users. To tune proactively
you must track fluctuations by hour-of-the-day, day-of-the-week and
Sophisticated Charting Options
Ion employs many forms
of data charting and provides you with a rich functionality of data charting
presentation. You can quickly adjust the visual representation of your
performance data to include trendlines, forecasts, averages, and more.
Ion supports chart
plotting for all main components of database load statistics. Ion supports
the ability to plot charts for different components of database performance
facilitating the task of finding the primary cause of the response time
Ion is designed by
senior DBA's for senior DBA's. Just like Oracle, the Ion interface is very
complex and it has every tuning area available including overall performance
metrics, system wait events, instance activity and memory statistics, plus detailed I/O metrics, aggregated by tablespace,
segment and data file. One shortcoming of almost every Oracle tuning tool is
that the tool does not mimic the problem-solving process of the DBA.
The interface must "make sense" and be organized hierarchically so the DBA
can drill-down into successive levels of detail. The unique ability of Ion
products is the ability to work with Oracle databases from workstations
with nothing but a Java Runtime Environment installed. This allows you to
start using Ion quickly and effectively from anywhere. Additionally, Ion does not require
any server-side installation, keeping your database clean and secure.
Created by Professionals, for Professionals
Ion mimics the thought
process of the DBA and has just what you need, where you need it. Ion has
quick access to all categories of database performance reports. You are able
to plot sophisticated charts by just a few mouse-clicks.
Fast response time component analysis
Ion allows you to quickly see all
components of response time. Furthermore, you are able to find what you
need quickly at any time by selecting ANY of hundreds of performance statistics to
be displayed at a glance. This premium functionality allows you to quickly
estimate database’s performance health and take corrective actions, if
Response Time Monitoring
Ion provides you with a
quick database health picture. The Expert interface analyzes your database and
returns an overview of performance as well as advice.
Custom Elapsed-time Analysis
With Ion you choose exactly the
time-series range that is important to your tuning problem. You can
chose any range you want, allowing you to see
elapsed time metrics at any level of granularity.
Fast Problem Identification
Real-time monitors can be too
transient to be useful. A complex Oracle performance issue might take
hours to diagnose, and the problem is always gone before you can ascertain
the root cause. Ion allows you to quickly do a post-mortem on any
performance problem, even if it is weeks after the incident. For any
snapshot period you can quickly locate SQL with the highest buffer gets,
executions, CPU consumption and elapsed time, allowing you to quickly find
the sub-optimal SQL.
Ion is able to generate
intelligent advice and hints by performing analysis of your STATSPACK or
AWR data. The analysis is HTML formatted and includes advice and comments
about all important database performance aspects.