|
|
| |
 |
|
Oracle Tips by Burleson |
Capturing Time-Series Metrics
The Oracle DBA has a wealth of Oracle performance information at
their fingertips, with more than 100 new dynamic performance
tables stored in the Automatic Workload Repository (AWR).
These AWR tables feed data to the totally reworked Enterprise
Manager (EM) to produce stunning time-series displays. AWR data
is used by the Automatic Database Diagnostic Monitor (ADDM) and
the SQL Tuning Advisor or by using the dbms_sqltune package to
make intelligent performance recommendations.
Instead of running complex scripts to track database performance
over time, the Oracle10g DBA now has detailed time-series
performance data immediately available for detailed analysis.
These industrial strength AWR tables are a blessing for the
Oracle tuning DBA. Oracle10g has new DBMS packages, such as the
dbms_sqltune and dbms_mview.explain_rewrite packages, that read
the wrh$ tables and carry out sophisticated performance
analysis. While not artificial intelligence in the truest sense,
these sophisticated tools help simplify the complex task of
Oracle tuning.
|
The above book excerpt is from:
 |
|
Oracle Silver Bullets
Real-world Oracle performance Secrets
Donald K. Burleson
ISBN 0-9759135-2-2
Retail Price $27.95
/ £10.95
Order now and
get immediate online access to the
code depot!
Only
$19.95
(30% off)
 |
http://www.rampant-books.com/book_2005_1_silver_bullet.htm |
|
|
