Oracle后台进程

Oracle实例包括两部分：SGA和 一组后台进程。后台进程执行保证数据库运行所需的实际维护任务。例如，有一个进程为我们维护块缓冲区缓存，根据需要将块写出到数据文件 等等。每个进程都专注于自己的任务，但是会与所有其他进 程协同工作。例如，负责写日志文件的进程填满一个日志后转向下一个日志时，它会通知负责对填满的日志文件进行归档的进程，告诉它有活干了。

可以使用一个V$视图查看所有可能的Oracle后台进程，确定你的系统中正在使用哪些后台进程：

scott@ORCL>select paddr, name, description
  2  from v$bgprocess
  3  order by paddr desc
  4  /

PADDR 		NAME 	DESCRIPTION
-------
000007FF634DF010 CJQ0  Job Queue Coordinator
000007FF634DDFA0 QMNC  AQ Coordinator
000007FF634DAE50 SMCO  Space Manager Process
000007FF634D9DE0 VKRM  Virtual sKeduler for Resource Manager
000007FF634D5C20 MMNL  Manageability Monitor Process 2
000007FF634D4BB0 MMON  Manageability Monitor Process
000007FF634D3B40 RECO  distributed recovery
000007FF634D2AD0 SMON  System Monitor Process
000007FF634D1A60 CKPT  checkpoint
000007FF634D09F0 LGWR  Redo etc.
000007FF634CF980 DBW0  db writer process 0
000007FF634CE910 MMAN  Memory Manager
000007FF634CD8A0 DIA0  diagnosibility process 0
000007FF634CC830 PSP0  process spawner 0
000007FF634CB7C0 DBRM  DataBase Resource Manager
000007FF634CA750 DIAG  diagnosibility process
000007FF634C96E0 GEN0  generic0
000007FF634C8670 VKTM  Virtual Keeper of TiMe process
000007FF634C7600 PMON  process cleanup
00               RSMN  Remote Slave Monitor
00               PING  interconnect latency measurement
00               FMON  File Mapping Monitor Process
00               ACMS  Atomic Controlfile to Memory Server
00               DSKM  slave DiSKMon process
00               DIA1  diagnosibility process 1
00               DIA2  diagnosibility process 2
00               DIA3  diagnosibility process 3
00               DIA4  diagnosibility process 4
00               DIA5  diagnosibility process 5
00               DIA6  diagnosibility process 6
00               DIA7  diagnosibility process 7
00               DIA8  diagnosibility process 8
00               DIA9  diagnosibility process 9
00               LMON  global enqueue service monitor
00               LMD0  global enqueue service daemon 0
00               LMS0  global cache service process 0
00               LMS1  global cache service process 1
00               LMS2  global cache service process 2
00               LMS3  global cache service process 3
00               LMS4  global cache service process 4
00               LMS5  global cache service process 5
00               LMS6  global cache service process 6
00               LMS7  global cache service process 7
00               LMS8  global cache service process 8
00               LMS9  global cache service process 9
00               LMSa  global cache service process 10
00               LMSb  global cache service process 11
00               LMSc  global cache service process 12
00               LMSd  global cache service process 13
00               LMSe  global cache service process 14
00               LMSf  global cache service process 15
00               LMSg  global cache service process 16
00               LMSh  global cache service process 17
00               LMSi  global cache service process 18
00               LMSj  global cache service process 19
00