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