mmon oracle,oracle 10g 中后台进程(MMON,MMNL,MMAN,RBAL,OSMB)的作用

Other Background Processes

There are several other background processes that might be running. These can include the following:

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

Issuing alerts whenever a given metrics violates its threshold value

Taking snapshots by spawning additional process (MMON slaves)

Capturing statistics value for SQL objects which have been recently modified

MMNL performs frequent and light-weight manageability-related tasks, such as session history capture and metrics computation.

MMAN is used for internal database tasks.

RBAL coordinates rebalance

activity for disk groups in an Automatic Storage Management instance. It

performs a global open on Automatic Storage Management disks.ORBn

performs the actual rebalance data extent movements in an Automatic

Storage Management instance. There can be many of these at a time,

called ORB0, ORB1, and so forth.

OSMB is present in a

database instance using an Automatic Storage Management disk group. It

communicates with the Automatic Storage Management instance.[@more@]