1.DBW0(DBWn):Database Writer Process
Checkpoint occur
Dirty buffers threshold reached
Not free buffers
Timeout
RAC ping request
Tablespace offline
Tablespace read only
Table Drop or Truncate
Tablespace BEGIN BACKUP
2.LGWR:Log Writer Process
At commit
When one-third full
When there is 1 MB of redo
Every 3 seconds
Before DBWn writes
3.CKPT:Checkpoint Process
Signalling DBWn at checkpoints
Updating datafile headers with checkpoint information
Updating control files with checkpoint information
4.SMON:system monitor process
Instance recovery:
-Rolls forward changes in the redo logs
-Open the database for user access
-Rolls back uncommitted transactions
Coalesces free space ever 3 sec
Deallocates temporary segments
5.PMON:Process Monitor
Clean up after failed processes by:
-Rolling back the transaction
-Releasing locks
-Releasing other resources
-Restarts dead dispatchers
6.ARCn:Archiver Processes
7.RECO:Recoverer Process(distribution database)
8.CJQ0(CJQn):Job Queue Processes
9.LMSn:RAC Lock Manager Server Process(Global Cache Service Processes)
10.LCKn:RAC Lock Manager -Instance Locks(The Lock Process )
11.LMON:RAC DLM Monitor -Global Locks(The Global Enqueue Service Monitor)
12.LMDn:RAC DLM Monitor -Remote Locks(The Global Enqueue Service Daemon)
13.DIAG:The Diagnosability Daemon(RAC)
14.QMNn:Queue Monitor Processes
15.Dnnn:Dispatcher Processes
16.Snnn:Shared Server Processes
17.Pnnn:Parallel Query Slaves
18.SNPn:Snapshot Fresh Processes
No Comments
Be the first to comment on this entry.
Leave a comment
Fields in bold are required. Email addresses are never published or distributed.
Some HTML code is allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>URLs must be fully qualified (eg: http://www.dbifan.com),and all tags must be properly closed.
Line breaks and paragraphs are automatically converted.
Please keep comments relevant. Off-topic, offensive or inappropriate comments may be edited or removed.