| |
 |
|
Oracle 11g SQL performance analyzer concepts
Oracle Tips by Burleson Consulting
January 16, 2008
|
The Oracle 11g SQL performance analyzer is a revolutionary new tool to allow
holistic SQL tuning with real-world workloads, rather than hit-and-miss SQL
performance analysis techniques such as adding hints and tuning with guesswork.
The 11g SQL Performance Analyzer (SPA) uses the dbms_sqltune package
to analyze SQL performance using SQL tuning sets, real workloads for
empirically-tested SQL performance analysis.
For full details on the 11g SQL Performance Analyzer, see the book “Oracle
11g New Features”, by Rampant TechPress, featuring John Garmany, plus Oracle
ACE’s Steve Karam, Lutz Hartmann, and VJ Jain.
See my additional resources for the 11g SQL Performance Analyzer:
 |
If you like Oracle tuning, you
might enjoy my book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get instant
access to the code depot of Oracle tuning scripts. |
|
