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