Oracle Database - ADDM (Automated Database Diagnostic Monitor) - Automatic Performance Diagnostics Tool
About
ADDM (Automated Database Diagnostic Monitor) is available since Oracle 10g.
are useful features for performance tuning and troubleshooting.
ADDM reports the most significant performance problems between AWR snapshots.
Whether a performance problem is captured by ADDM depends then on its duration compared to the interval between AWR snapshots (default of one hour)
Articles Related
ADDM analysis
ADDM analyses a number of database-related problems
- Memory-related issues such as shared pool latch contention, log buffer issues, or database buffer cache related problems
- CPU bottlenecks
- Disk I/O performance issues
- Database configuration problems
- Space-related issues, such as tablespaces running out of space
- Application and SQL tuning issues such as excessive parsing and excessive locking
You can use Oracle Enterprise Manager (OEM) to view the ADDM findings.