|
Trend Analysis and Oracle
Silver Bullets
Savvy
Oracle tuning professionals know that reactive tuning has
limited value and the real key to success is time-series
tuning.
Third-party
tools such as the STATSPACK Viewer and the Workload Interface
Statistical Engine (Ion) capture Oracle AWR and STATSPACK data
easily and allow the DBA to visualize the data aggregated by
averages for day-of-the-week and hour-of-the day.
The Ion tool is
inexpensive and it provides a time-saving tool for plotting
Oracle performance trends and repeating signatures for
performance metrics (www.ion-dba.com). Moreover, Oracle
DBA’s have the unique ability to visually represent AWR
information using the Ion tool by drawing on numerous reports
run against dba_hist tables. The Ion tool provides DBA’s with
a convenient framework to work with AWR performance data and
produce charts to support proactive tuning. Throughout the
remainder of this book, information will be presented on how a
graphics tool like Ion can be used to facilitate proactive
tuning and help the DBA find silver bullets. The knowledge of
aggregated average values by day-of-the-week and hour-of-the-day
can assist in the proper configuration of Oracle. |
