查看、清除mmon suspended 状态

经常mmon slave进行AWR快照生成或其它处理发生性能问题，超过Runtime limit或CPU time limit后，mmon会变为suspended状态,需要解除mmon suspended状态,可能会用到，记录一下方法。

检查mmon suspended状态

SQL>
SQL> oradebug setmypid
Statement processed.
SQL> oradebug unit_test kebm_dmp_slv_attrs kewrmafsa_
Status: 3
Flags: 0
Runtime limit: 900
CPU time limit: 300
Violations: 0
Suspended until: 1612795496 <<<<<---- not zero indicates that MMON is still suspended.
SQL>

解除mmon suspended状态

SQL> oradebug unit_test kebm_set_slv_attrs kewrmafsa_ retain retain retain retain 0 0
Modified attributes of kewrmafsa_ (slave id 13)
SQL>