Real-Time ADDM

ADDM is further enhanced in the new Enterprise Manager Cloud Control 12c version with a real-time feature. This is known as Real-Time ADDM (supported for any Oracle database Target of version 10.2.0.4 and higher) and is very useful for situations when the database has become very slow, or has hung and normal ADDM cannot work since it may not be possible to even log in to the database. Even if it is possible to log in to the database, taking an AWR snapshot or running an ADDM task may worsen the problem.

Sometimes it may be due to just one blocking session that the entire database arrives at this unresponsive state.

Often, not being able to find out the root cause of the problem, DBAs may resort to bouncing the database to fix the ...

Get Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.