Tuesday, April 20, 2010

Oracle Background Processes

The Background Processes

MMON – This process performs various manageability-related background tasks, for example:

  • Issuing alerts whenever a given metrics violates its threshold value

  • Capturing statistics value for SQL objects which have been recently modified

MMNL - This process performs frequent and lightweight manageability-related tasks, such as session history capture and metrics computation.

MMAN - is used for internal database tasks that manage the automatic shared memory. MMAN serves as the SGA Memory Broker and coordinates the sizing of the memory components.

No comments:

Post a Comment