Ion. Intelligent Oracle Tuning



Free Trial

Buy It Now


Product Tour

Technical Support



About Ion

Contact Us


  Rampant Techpress
  Home   View Cart

Why Use Ion?

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:

Save Money

Oracle 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.

Ion has many of these features and uses can use the free STATSPACK utility if AWR is not an option.

Trend Visualization

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 significant.

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 the Oracle.

Multivariate Signature Analysis

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 day-of-the-month.

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.

Load Profiles

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 slow-downs.

Sophisticated Interface

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 required.

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. 

Built-in Intelligence

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.

For More Information


Rampant Techpress. P.O. Box 511, Kittrell, NC 27544

Copyright © 2008-2014  by Burleson. All rights reserved.
Oracle® is the registered trademark of Oracle Corporation.