SQL> select name,description from v$bgprocess where paddr<>'00';
NAME DESCRIPTION
----- ----------------------------------------------------------------
PMON process cleanup
DIAG diagnosibility process
PSP0 process spawner 0
LMON global enqueue service monitor
LMD0 global enqueue service daemon 0
LMS0 global cache service process 0
LMS1 global cache service process 1
MMAN Memory Manager
DBW0 db writer process 0
ARC0 Archival Process 0
ARC1 Archival Process 1
NAME DESCRIPTION
----- ----------------------------------------------------------------
LGWR Redo etc.
LCK0 Lock Process 0
CKPT checkpoint
SMON System Monitor Process
RECO distributed recovery
CJQ0 Job Queue Coordinator
QMNC AQ Coordinator
MMON Manageability Monitor Process
MMNL Manageability Monitor Process 2
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/216109/viewspace-1002506/ ，如需转载，请注明出处，否则将追究法律责任。
