Status for ADDM advisory is RUNNING
OMS: Oracle Enterprise Manager 11g Release 1 Grid ControlTarget Database: 11.2.0.1.0
In the list of ADDM advisory tasks, 48 out 165 are in RUNNING status. I observed this pattern in only two databases.
The alert log has following different kinds of messages related to MMON process.
Suspending MMON slave action kewrmafsa_ for 82800 seconds
Suspending MMON slave action kewrmapsa_ for 82800 seconds
Suspending MMON slave action kehslave_ for 82800 seconds
Suspending MMON slave action keataskmaintenance_ for 82800 seconds
Suspending MMON action 'undo usage' for 82800 seconds
When i manually ran ADDM, it completed successfully (318 seconds). The longest duration for ADDM advisor task was 762 seconds. The AWR details are as follows:
In the list of ADDM advisory tasks, 48 out 165 are in RUNNING status. I observed this pattern in only two databases.
The alert log has following different kinds of messages related to MMON process.
Suspending MMON slave action kewrmafsa_ for 82800 seconds
Suspending MMON slave action kewrmapsa_ for 82800 seconds
Suspending MMON slave action kehslave_ for 82800 seconds
Suspending MMON slave action keataskmaintenance_ for 82800 seconds
Suspending MMON action 'undo usage' for 82800 seconds
When i manually ran ADDM, it completed successfully (318 seconds). The longest duration for ADDM advisor task was 762 seconds. The AWR details are as follows:
0