Oracle Database - ADDM (Automated Database Diagnostic Monitor) - Automatic Performance Diagnostics Tool

Card Puncher Data Processing

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)

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.





Discover More
Card Puncher Data Processing
Oracle Database - AWR (Advanced|Automatic) - Workload Repository - Performance Statistics Gathering Tool - DBA_HIST views

(available since Oracle 10g) AWR collects (through snapshots), processes, and maintains performance statistics. Several tools such as ADDM (Automated Database Diagnostic Monitor), AWR Reports analyses...



Share this page:
Follow us:
Task Runner