重启mmon、mmnl进程

[oracle@test ~]$ ps -ef|grep mmon
oracle    4031     1  0 14:40 ?        00:00:00 ora_mmon_test
oracle    4143  2997  0 14:46 pts/1    00:00:00 grep mmon

[oracle@test ~]$ kill -9 4031
[oracle@test ~]$ ps -ef|grep mmon
oracle    4747  2997  0 15:06 pts/1    00:00:00 grep mmon
[oracle@test ~]$ ps -ef|grep mmnl
oracle    4035     1  0 14:40 ?        00:00:00 ora_mmnl_test
oracle    4749  2997  0 15:06 pts/1    00:00:00 grep mmnl

[oracle@test ~]$ ps -ef|grep mmnl
oracle    4752  2997  0 15:07 pts/1    00:00:00 grep mmnl

[oracle@test ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 14 15:07:09 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>  alter system enable restricted session;

System altered.

SQL> alter system disable restricted session;   

System altered.
[oracle@test ~]$ ps -ef|grep mmon
oracle    4764     1  0 15:07 ?        00:00:00 ora_mmon_test
oracle    4801  2997  0 15:08 pts/1    00:00:00 grep mmon
[oracle@test ~]$ ps -ef|grep mmnl
oracle    4768     1  0 15:07 ?        00:00:00 ora_mmnl_test
oracle    4805  2997  0 15:08 pts/1    00:00:00 grep mmnl