 |
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!
Ion v3 will include data mining features that submit background
tasks to identify salient workloads. Starting with general
cohorts (OLTP and DSS), Ion v3 will perform pattern matching to
categorize each workload period as OLTP and DSS
1 - Searches AWR/STATSPACK for repeating changes to workloads
a) For HOD - Analyze by hour of the day to find patterns of
similar usage by:
1) Display max(physical reads)
2) Transaction characteristics (high repeated executions, low I/O
for OLTP)
b) For DOW - Analyze cohorts for day of the week
2 - Recommend - Ion v3 will then justify the answer with data and
make suggestions about what/when to change in terms of
initialization parameters or changes to CBO statistics.
 -
feature coming soon
|
WARNING
ION is designed exclusively for senior Oracle tuning
professionals
and it is not appropriate for beginners.
|
|
|
 |
- Multivariate Signature
Analysis
- Sophisticated Charting
Options
- Created by Professionals,
for Professionals
-
Fast response time component analysis
- Custom
Elapsed-time Analysis
-
Fast Problem Identification
|
|
|
