The types of problems that ADDM considers include the following:
• CPU bottlenecks - Is the system CPU bound by Oracle Database or some other
application?
• Undersized Memory Structures - Are the Oracle Database memory structures, such as
the SGA, PGA, and buffer cache, adequately sized?
• I/O capacity issues - Is the I/O subsystem performing as expected?
• High-load SQL statements - Are there any SQL statements which are consuming
excessive system resources?
• High-load PL/SQL execution and compilation, and high-load Java usage
• Oracle RAC specific issues - What are the global cache hot blocks and objects; are there
any interconnect latency issues?
• Sub-optimal use of Oracle Database by the application - Are there problems with poor
connection management, excessive parsing, or application level lock contention?
• Database configuration issues - Is there evidence of incorrect sizing of log files, archiving
issues, excessive checkpoints, or sub-optimal parameter settings?
• Concurrency issues - Are there buffer busy problems?
• Hot objects and top SQL for various problem areas
