print Printer View e-mail E-mail this page Bookmark Bookmark
 

Oracle Database Manageability


Automatic Performance Diagnosis

Part of the Oracle Diagnostics Pack 10g, the Automatic Workload Repository (AWR) is a built-in repository within every Oracle Database 10g database that contains operational statistics about that particular database. AWR is the foundation for all self-management functionality of Oracle Database 10g, including the Automatic Database Diagnostics Monitor (ADDM). ADDM is a self-diagnostic engine built right into the Oracle Database 10g kernel. It is a revolutionary performance self-diagnostic solution that enables the Oracle Database 10g to automatically diagnose its performance problems, completely liberating administrators from this complex task. AWR, ADDM along with proactive and efficient Server-generated alerts form a complete solution for monitoring and diagnosing the performance of a database.


Technical Information
Oracle Diagnostics Pack Data Sheet PDF
The Self-Managing Database: Automatic Performance Diagnosis PDF
The Self-Managing Database: Automatic Health Monitoring and Alerting PDF
Performance Analysis with the Oracle Database 10g's Active Session History PDF
   
Demos
Oracle Database 10g: Performance Diagnostics and SQL Tuning
     
Other Relevant Articles
New Perform Without Waiting
Talking Tuning: Advice and Consent PDF
The Top 20 Features for DBAs: Automatic Workload Repository PDF
   
Oracle World 2003 Presentations
Oracle Database 10g: The Self-Managing Database PDF
The Self-Managing Database: Automatic Performance Diagnosis PDF
The Self-Managing Database: Automatic Health Monitoring and Alerting PDF
     
 
 
Left Curve
Key Manageability Features
 Right Curve
 · Automatic Performance Diagnosis
 · Automatic SQL Tuning
 · Automatic Memory Management
 · Proactive Space Management
 · Automatic Storage Management
 · Easy, Lightweight Install and Upgrade
 · Resource Manager
 · Scheduler

Left Curve
Learn More
 Right Curve
 · Manageability Technology Center
 · Oracle Database 10g New Manageability Features Seminar
 · Oracle By Example Hands-On Tutorials
 · Learn Oracle in 2 Days
 · Oracle 10g Books

Left Curve
Previous Releases
 Right Curve
 · Oracle9i Database Release 2
 · Oracle Database 10g
Release 1

Left Curve
Discussion Forums
 Right Curve
 · Database
 · Oracle Enterprise Manager
 · PL/SQL
 · SQL/JDBC
 · SQL*Plus
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy