For which three problem categories does Automatic Database Diagnostic Monitor (ADDM)
provide analysis and recommendations by default?(Choose three.)
A.
for network stack-related bandwidth contention
B.
for concurrency issues because of buffer busy problems
C.
for high-load PL/SQL execution and compilation, and high-load Java usage
D.
for application-level lock contention.
B,C,D
B,C,D
A is wrong because ADDM check the following problem areas
https://docs.oracle.com/cd/E25178_01/server.1111/e16638/diag.htm
– CPU bottlenecks – Is the system CPU bound by Oracle or some other application?
– Undersized Memory Structures – Are the Oracle 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, as well as high load Java usage
– RAC specific issues – What are the global cache hot blocks and objects; are there any interconnect latency issues?
– Sub-optimal use of Oracle 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