If the Mmon process is killed, will it start automatically?

Source: Internet
Author: User

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?

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.