AWR(Automatic Workload Repository)

在Oracle10g中，有两个后台进程(MMON/MMNL)是新增的:

MMON  Memory Monitor 

MMNL  Memory Monitor Light
这个进程的主要作用如下：

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.

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.