The manageability monitor process (MMON) performs tasks related to the Automatic Workload Repository (AWR). This includes gathering statistical information on the database, collecting AWR snapshots, initiating various automated maintenance jobs and generating warning messages for tasks that have exceeded their threshold values.
一般情况下,我们KILL这个进程之后,pmon进程会自动重新拉起这个mmon进程
但是有一种情况下,pmon进程不会自动拉起这个进程。
SQL> alter system kill session '70,1';