Question: What are the QMON
background process called? I do not see any process
called QMON when I do a "ps –ef|grep –I qmon".
What are the QMON processes and their functions?
Answer: The QMON background process names
are determined by your release of Oracle:
Pre 10g: Prior to
10g, Oracle has QMNx (where x=0 . . .n), such that you may
observe a background process named qmno_. In release
prior to 10g the QMON processes were controlled by the
aq_tm_processes parameter. It was used to
control the
behavior of this spawning of AQ slaves (the maximum number
of slave processes for advanced queuing), and
aq_tm_processes should never be set to a value of zero.
10g and beyond: In
10g and beyond, there is no process called QMON, the term
query monitor (QMON) is a term that describes the query
monitor coordinator (Queue Monitor Coordinator (QMNC) and
all of the sub-processes spawned by
QMNC,
processes with the names Q01, Q02, etc.
This QMNC
process is responsible for facilitating various background
activities required by Advanced Queuing (AQ) and Oracle
Streams. The QMNC process was introduced in 10g
release 1, and it is responsible for allocating tasks to the
QMON sub-processes (q01, q02, . . . ) . In 10g and
beyond, the aq_tm_processes parameter is not used.
Also see these related QMON Notes: