The Guru's agree, Ion is the best: Ion has built-in intelligence that is critical for solving complex tuning problems. It's clearly the best Oracle tuning software on the market. Steve Karam Oracle Certified Master

Created by Donald K. Burleson Built-in intelligence finds problems fast Spot trends with time-series regression See all components of Oracle response time Easily spot hidden resource bottlenecks Predict problems before they cripple your database. Supports Oracle 8i through 11g. Ion Enterprise Download Special Introductory Price Oracle Databases Total License Fee, US$ Download Each Instance $1,995 Unlimited Instances $9,995 WARNING ION is designed exclusively for senior Oracle tuning professionals and it is not appropriate for beginners.

Ion Oracle Features Summary The below list shows you a list of available features supported by Ion. Note that this list contains only the key software features. More detailed information about all the software features and abilities is available in the documentation delivered with the software product. - feature supported Versions AWR STATSPACK Oracle9i STATSPACK Oracle10g STATSPACK Oracle11g AWR Oracle10g AWR Oracle11g Features AWR STATSPACK Provides proactive trend visualization and forecasting Spot hidden trends quickly and easily without poring over pages of data Visualize hourly and daily changes on any metric Analyze overall trends, deltas, and forecasts with the click of a button No database installation required, client runs on nearly any OS Generate charts and discover trends Specialized historical reports on proven areas of concern including full table scans, hard parses, CPU usage, physical disk usage, and more SQL discovery support to find objects and queries of concern Expert advice - find out what those complex reports really mean to you Easy to use GUI interface - less frills, more function Ability to save charts to your local computer. Ability to print reports and charts Ion Oracle Features Breakdown Ion Oracle is a revolutionary new performance tuning tool, featuring state of the art analysis of your Oracle database. With Ion Oracle, you will be able to get a unique view of the performance signature of your Oracle system. Never again wonder what your bottlenecks are, where the problem lies, or why performance is just bad. Ion Oracle is formed of three integral parts: Ion Expert - Analyzes wait events, I/O, parameters, and more to deliver advice tailored to your system Ion Metrics - Allows you to plot any metric, viewing the data over time, averaged by hour of day or day of week, and even with trendlines and forecasting! Ion Scripts - Decades of experience and knowledge right at your fingertips! Ion Scripts give you over a hundred useful scripts in graphical and text forms, to help you analyze your system. Upcoming Features in ION V3 These are some of the future enhancements you can expect from the ION project, already in the works! - feature coming soon Features ION Enabled Drill down to core components on nearly any metric - parameter capable intelligent scripts Real-time tuning and monitoring - Including ASH and v$ views Customizable Healthcheck reports - Build your own statistics report your way ADDM Interface for 10g and 11g Wait Events Interface for detailed wait monitoring at the session and system level Historical and real-time wait monitoring Hot Block monitor Expanded latch and lock monitoring Current and historical object details on tables, indexes, materialized views, and more Custom Dashboards for regular monitoring Object and database growth tracking More scripts!