The manageability monitor process supports the Automatic
Workload Repository (AWR) by capturing statistics, monitoring
thresholds, and taking snapshots.
This is related to performance tuning and troubleshooting.
Restart MMON process without bouncing the database:
alter system enable restricted session;
alter system disable restricted session;
check status of mmon process, if it found as not running. $ ps -ef |grep mmon SQL> grant restricted session to public; SQL> alter system enable restricted session; SQL> alter system disable restricted session; SQL> revoke restricted session from public;
The manageability monitor process (MMON) performs many tasks related to the Automatic Workload Repository (AWR).
For example, MMON writes when a metric violates its threshold value, taking snapshots, and capturing statistics value for recently modified SQL objects.
Catch Me On:- Hariprasath Rajaram Telegram:https://t.me/joinchat/I_f4DkeGfZuxgMIoJSpQZg LinkedIn:https://www.linkedin.com/in/hariprasathdba Facebook:https://www.facebook.com/HariPrasathdba FB Group:https://www.facebook.com/groups/894402327369506/ FB Page: https://www.facebook.com/dbahariprasath/? Twitter: https://twitter.com/hariprasathdba