Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

By reducing DB time, the database is able to support more user requests using the same resources, which increases throughput.

By reducing DB time, the database is able to support more user requests using the same resources, which increases throughput. The problems reported by ADDM are sorted by the amount of DB time they are responsible for. System areas that are not responsible for a significant portion of DB time are reported as non-problem areas. 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, e

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question