What is MMON process in Oracle?

MMON (Manageability Monitor) is a background process that gathers memory statistics (snapshots) and stores this information in the AWR (automatic workload repository). MMON is also responsible for issuing alerts for metrics that exceed their thresholds. This process was introduced in Oracle 10g.

What are the 5 mandatory background processes in Oracle?

Mandatory background processes are DBWn, LGWR, CKPT, SMON, PMON, and RECO. All other processes are optional, will be invoked if that particular feature is activated. Oracle background processes are visible as separate operating system processes in Unix/Linux.

What is Oracle background process?

The background processes of the Oracle instance manage memory structures, asynchronously perform I/O to write data to a file on a disk, and perform general maintenance tasks. The database writer writes modified blocks from the database buffer cache to the files on a disk.

What are the background processes in Oracle 11g?

The background processes in an Oracle instance can include the following:

• Database Writer Process (DBWn)
• Log Writer Process (LGWR)
• Checkpoint Process (CKPT)
• System Monitor Process (SMON)
• Process Monitor Process (PMON)
• Recoverer Process (RECO)
• Job Queue Processes.
• Archiver Processes (ARCn)

What is the role of mmon in Oracle Database?

Restart MMON process in oracle database. 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 .

How to define background processes in Oracle Database?

F Background Processes. Table F-1 describes Oracle Database background processes. In this context, a background process is defined as any process that is listed in V$PROCESS and has a non-null value in the pname column. The External Properties column lists the type of instance in which the process runs.

What does mmon ( manageability monitor ) background process do?

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.

How to restart mmon process in Oracle Database?

1. Grant restricted session to public: This grant is required to avoid any impact on the sessions connecting to database. 2. Enable and disable restricted sessions Enabling and disabling will start the MMON process. 3. Revoke the restricted session: 4. Check MMON process;