AWR Snapshots Not Generated With "Reliable Messages" Waits - Bug 26961929
exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();
is not getting completed after long time also, so terminated it manually after collecting orabug trace.
1. Upgrade to 18.1 where this is first included.
or
2. Apply Patch 26961929 which will enforce a runtime policy that will prevent any action to run indefinitely
or
3. Use workaround:
Restart MMON process by using "kill -9" against its process ID on all RAC instances - MMON process will be re-spawn
exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();
is not getting completed after long time also, so terminated it manually after collecting orabug trace.
1. Upgrade to 18.1 where this is first included.
or
2. Apply Patch 26961929 which will enforce a runtime policy that will prevent any action to run indefinitely
or
3. Use workaround:
Restart MMON process by using "kill -9" against its process ID on all RAC instances - MMON process will be re-spawn
