What kind of performance issues does ADDM look for?
ADDM looks for a wide variety of performance issues covering Oracle DB, Operating System, Network and Application. It includes performance issues most commonly seen by typical Oracle customers and their configurations. Here is a general overview of the types of issues ADDM can detect and diagnose (*not a comprehensive list): – CPU bottlenecks due to Oracle as well as non-Oracle loads – Top SQL statements along with top objects identified by different dimensions: CPU, elapsed, IO bandwidth, latency,interconnect traffic in RAC – Top statements by PL/SQL and Java execution times – IO bandwidth: Bottlenecks due to various reasons like few hot files, checkpointing, log file sizes, or MTTR settings – Parsing: Too many hard or soft parses due to various reasons – Configuration issues: Small log file sizes or small log buffer sizes or inefficient MTTR settings. – Application issues: Too much contention on particular rows or particular objects – Excessive login/logoff – Undersized memory segmen
