oracle mmon 4194,Oracle10g 中AWR相关的两个新后台进程MMON及MMNL

Oracle10g新后台进程MMON及MMNL进程

在Oracle不同的文档中，对这两个进程的解释存在歧义。

MMON 应该是 Memory Monitor 的缩写，但是在有的文档中被记录为Manageability

Monitor ，这应当是10g早期版本中的称呼，只不过后来发生了变更。

MMON 进程的主要作用如下：

The memory monitor (MMON) process was introduced in 10g and is associated

with the Automatic Workload Repository new features used for automatic

problem detection and self-tuning. MMON writes out the required statistics

for AWR on a scheduled basis.

另外一个进程是MMNL ，是 Memory Monitor Light (MMNL) 的缩写，在部分文档中

记录为 Manageability Monitor Light .

MMNL 进程的作用如下：

The Memory Monitor Light (MMNL) process is a new process in 10g which works

with the Automatic Workload Repository new features (AWR) to write out full

statistics buffers to disk as needed.

转载自