which three problem categories does Automatic Database …

For which three problem categories does Automatic Database Diagnostic Monitor (ADDM)
provide analysis and recommendations by default?(Choose three.)

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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


carlosegf

carlosegf

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