O'Reilly logo

Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos by Porus Homi Havewala

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Doctor in the database

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:

Doctor in the database

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required