The database is a 11.2.0.4.0 version of RAC.
Two nodes are 6 hours apart and cannot automatically generate an AWR report. Business Normal
1. Manually creating the snapshot is OK.
2. Check the alert log and Mmon logs.
3. Kill the Mmon process on the test library and the process cannot start automatically.
4. In the test library to modify the _swrf_mmon_flush parameters, the Mmon process can automatically get up
Alter system set "_swrf_mmon_flush" =FALSE;
Alter system set "_swrf_mmon_flush" =true;
5. On a node in the production library, the _swrt_mmon_flush parameter is modified or the AWR cannot be generated
6. The kill Mmon process on the production depot, Mmon still cannot automatically start up
7. After about 5 hours, the production library did not manually kill the Mmon process node Awr report normal generation; Kill the node of the Mmon process, Mmon process is not started, of course, can not generate AWR
8. According to Trace (Mmon's slave process trace), check MoS, online also, ora-12751
DDE rules only execute for:ora-12751
Subsequent plans to perform the following statements that collect statistics:
exec dbms_stats.gather_fixed_objects_stats;
exec dbms_stats.gather_schema_stats (' SYS ');
The statistics of SYS are considered before, because the AWR generation is particularly slow and takes more than 5 minutes.
If the Mmon process is killed, will it start automatically?