StatspackAnalyzer Project Goals
Since the dawn of Oracle database management, Oracle DBA's have struggled to
interpret the plethora of statistics that are provided by the Oracle
time-series performance reports, and the Oracle community has always desired
a software tool that could apply basic decision rules to generic STATSPACK
and AWR reports.
Interpreting an Oracle STATSPACK/AWR report will always be complex and it
would take a massive effort to fully replicate the analysis of a human Oracle
tuning expert.
On the other hand, it is possible to create and quantify basic decision rules
(heuristics) that can be generalized and applied to all STATSPACK and AWR
reports. That was the impetus for the statspackanalyzer expert systems
project.
What is StatspackAnalyzer?
StatspackAnalyzer is a true expert system that seeks to codify expert DBA
knowledge and advice against any STATSPACK or AWR report. The well-structured
decision rules of expert Oracle tuning specialists were collected, quantified
and then generalized and validated against real-world STATSPACK and AWR
reports.
While no automated tool can fully replicate the decision processes of a human
DBA tuning expert, statspackanalyzer makes observations about exceptional
conditions within the STATSPACK or AWR report. The StatspackAnalyzer tool was
never intended to replace the human intuition of an Oracle performance
expert, and all observations from statspackanalyzer should be validated with
a human expert.
Contributors
The following individuals have contributed their expert advice to the
creation of the business rules in StatspackAnalyzer.com:
Don Burleson
Don Burleson is one of the world's most prolilfic Oracle authors and experts.
A retired adjunct professor emeritus, he has authored more than 30 books on
Oracle database management, published hundreds of articles in national
magazines, and is a popular lecturer at international database conferences. Don
crafted many of the original rules that form the foundation of
StatspackAnalyzer.com.
Jamon Bowen
Jamon Bowen is an Oracle performance engineer at Texas Memory Systems, Inc. Jamon
contributed rules related to interpretation of I/O related wait events and
I/O table performance data. These rules reflect a growing understanding of
the ways that solid state disks improve performance for Oracle databases.
If you are interested in contributing new business rules for
StatspackAnalyzer.com, please click here.
Evaluators
The following individuals have contributed their expert advice to the
evaluation of the StatspackAnalyzer.com rules.
Steve Karam
Steve Karam is one of less than 20 DBA's worldwide to achieve the coveted
Oracle 10g Certified Master status and he has been honored with the
prestigious Oracle ACE designation. A former senior instructor for
Oracle
University
, Steve has a proven track
record in performance and troubleshooting on dozens of high profile Oracle
systems, and complex Oracle 10g RAC environments.
Tony Jambu
Tony Jambu is a veteran Oracle consultant with more than 17 years experience
in tuning real world databases. As a senior consultant for Precise Software,
Tony assists with the tuning of complex Oracle databases around the world.
Tony is the author of the popular SELECT Star column in the International
Oracle User Group SELECT Journal and serves as a board member for the
Australian Oracle Users Group.
If you are interested in evaluating the complete rules behind
StatspackAnalyzer.com, please click here.
Sponsors
StatspackAnalyzer.com would not exist without its sponsors, Texas Memory Systems and Burleson
Consulting who have generously funded development of the website.
If you are interested in being a sponsor for StatspackAnalyzer.com, please click here.
|
