Database Reference
In-Depth Information
QMNn
QMNn or Queue Monitor processes (QMN0 to QMN9) is an
optional background process for Oracle Advanced Queuing and
monitor the message queues. The init,ora parameter
AQ_TM_PROCESSES specifies the number of queue monitor
processes. Oracle Advanced Queuing gives the ability to
distributed applications to communicate asynchronously using
messages.
Dnnn or Dispatcher Process(es)
Dnnn or Dispatcher process is only available if you run Oracle
system in Shared Server mode. It is prime job is to take the
request from the connected user and place in the in the Request
Queue. Server process when its free picks up the request from
the request queue and put the response back in the “Response
Queue” after processing the request. Dispatcher process when
it's free picks that response from the response queue and sends it
back to the user who submitted that request. You can have
multiple Dnnn processes for single Database Instance.
Snnn or Shared Server Process(es)
Snnn process works exactly the same manner like the Dedicated
Server process except that the Shared Server processes utilizing
the beauty of Dispatcher process and Request and Response
Queue can server more than one user. The number of Shared
Server processes can be controlled using two init.ora parameters,
SHARED_SERVERS and MAX_SHARED_SERVERS.
MMAN (Memory Manager) is a background process that
manages the dynamic resizing of overall SGA memory areas as
the workload increases or decreases.
Search WWH ::
Custom Search