 |
|
SQL
Performance Analyzer (SPA) in Oracle 11g
Oracle 11g New Features Tips by Burleson
Consulting
July 8, 2008
|
Oracle 11g SQL New Features Tips
In this section of the chapter, SQL Performance
Analyzer will be used to predict the impact of changes to the database
system on SQL statements in a workload. This feature is useful for
DBAs who want to foresee changes in performance of a workload caused
by changes to their system as well as for developers who need to know
what happens when they apply change to schemas, applications or
database objects.
The following situations are good
candidates for the SQL Performance Analyzer:
-
Upgrades of the database
-
Accepting recommendations
for tuning
-
Changes to schema
-
Gathering of new
statistics for the optimizer
-
Parameter changes for the
instance
-
Changes to the hardware
-
OS patches
These are the steps
of a typical SQL Performance Analyzer workflow:
-
Capture the SQL workload on the production
system for testing.
-
Ship the captured workload to a test system.
-
Gather performance statistics for the
workload before changes are applied to the test system.
-
Apply changes to the test system.
-
Gather performance statistics for the
workload after changes are applied to the test system.
-
Compare the performance results for the two
test runs and identify regressing SQL statements.
-
Tune the regressing SQL statements.
This is an excerpt from the new book
Oracle 11g New Features: Expert Guide to the Important New
Features by John Garmany, Steve Karam, Lutz Hartmann, V. J. Jain,
Brian Carr.
You can buy it direct from the publisher for 30% off.
|
