-
Book Overview & Buying
-
Table Of Contents
Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos
By :
What is also important is that the database home page shows the latest ADDM findings. This is a proactive diagnostics engine that runs every hour by default on the database, and generates a list of recommendations.
Clicking on the ADDM Findings button takes you to the last ADDM Performance Analysis page, which is displayed in the following screenshot:

Informational findings are also shown. ADDM lets you know if the database is CPU-bound or I/O-bound, it lets you know of hard/soft parse issues, top SQL statements impacting the database, any locking issues, and so on.
ADDM is also RAC aware and informs you if there are any networking/interconnect or database configuration issues affecting the performance of the RAC database. For example, improper database sequence usage can have a severe performance impact on such active/active databases.
You can run ADDM at any time by going to Performance | Advisors Home on the menu and then selecting ADDM from the list of advisors available...
Change the font size
Change margin width
Change background colour