📋Steps in this guide1/3

Restart MMON process in oracle database -DBACLASS DBACLASS

The job of MMON( Manageability Monitor) background process is to perform tasks like taking AWR snapshots and automatic diagnostic analysis. Sometime, MMON process crashes or get suspended . Follow below steps to restart the MMON process: 1. Grant restricted session to public: This grant is required to avoid any impact on the sessions connecting to […]

oracle configurationintermediate

by OracleDba

14 views

Overview

The job of MMON ( Manageability Monitor) background process is to perform tasks like taking AWR snapshots and automatic diagnostic analysis. Sometime, MMON process crashes or get suspended . 1. Grant restricted session to public: This grant is required to avoid any impact on the sessions connecting to database.

Section 2

2. Enable and disable restricted sessions Enabling and disabling will start the MMON process. 3. Revoke the restricted session:

Code/Command (click line numbers to comment):

grant restricted session to public;

alter system enable restricted session;

alter system disable restricted session;

Section 3

4. Check MMON process;

Code/Command (click line numbers to comment):

1
2
3

revoke restricted session from  public;

ps -ef | grep mmon

Comments (0)

Please to add comments

No comments yet. Be the first to comment!