Wednesday, March 31, 2010

Oracle 11g background processes

Oracle 11g process:

  • smon
  • lgwr
  • dbwr (multiple process)
  • chkpt
  • pmon
  • mmon
    • process to collect statistics for AWR
  • mmnl
    • process to perform manageability related task
  • mman
    • process to manage automatic shared memory
  • pnnn (optional)
    • Process for parallel query operations
  • vktm (Virtual keeper of time
    • Process tracks wall-clock time and is used as a reference time counter
  • dia0
    • Diagnostic process to detects and resolve hangs and deadlocks
  • diag
    • Diagnosability capture process for performing diagnostic dumps
  • dbrm
    • Database resource management process
  • psp0
    • Process spawner to spawn oracle process as needed
  • reco
    • recoverer process
  • d000
    • dispatcher process to listen to and receive request from connected sessions
  • s0000
    • shared server process
  • smco
    • Space management co-ordinator ...spawns wnnn proces to carry out the task
  • fbda
    • flashback data archiver process
  • cjq0
    • Job queue process used for batch processing
  • gen0
    • General tak execution process
  • qmnc
    • Advanced queing coordination process. Spawns Qnnn process as needed

No comments:

Post a Comment