Asked by: Osmel Zinkgraf
asked in category: General Last Updated: 29th April, 2020

What is MMON 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.

Click to see full answer.


Subsequently, one may also ask, what is w000 process Oracle?

MMAN dynamically adjust the sizes of the SGA components like buffer cache, large pool, shared pool and java pool and serves as SGA memory broker. It is a new process added to Oracle 10g as part of automatic shared memory management.

Also Know, what is Ckpt process in Oracle? CKPT (Oracle Checkpoint Process) is an Oracle background process that timestamps all datafiles and control files to indicate that a checkpoint has occurred. The "DBWR checkpoints" statistic (v$sysstat) indicates the number of checkpoint requests completed.

Also to know, what is the use of Oracle?

Oracle is One of the DATABASE language its used for Create database,tables,records…etc… An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.

What is Lgwr?

LGWR (LoG WRiter) is an Oracle background process created when you start a database instance. The LGWR writes the redo log buffers to the on-line redo log files. If the on-line redo log files are mirrored, all the members of the group will be written out simultaneously.

39 Related Question Answers Found

What is Smon and Pmon in Oracle?

What is m000 background process in Oracle?

What is RECO in Oracle?


What is user process and server process in Oracle?

What is RECO in Oracle database?

How does Oracle background process work?


What is mandatory background process in Oracle 11g?

What are the background processes in ASM?

Is Oracle a programming language?


What is Oracle best known for?

Is Oracle an ERP?

Is Oracle easy to learn?


How do you manage data in Oracle?

Why is Oracle DB so popular?