Table of Contents
Oracle Database - ADDM (Automated Database Diagnostic Monitor)
About
Oracle AWR (Advanced Workload Repository) and ADDM (Automated Database Diagnostic Monitor) which are available since Oracle 10g are useful features for performance tuning and troubleshooting.
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.
