v$bgprocess

--------------

记录系统中后台进程的情况
有5个字段

SQL> desc v$bgprocess
Name           Type
------------- ----------------
PADDR          RAW(8)
PSERIAL#       NUMBER
NAME           VARCHAR2(5)
DESCRIPTION    VARCHAR2(64)
ERROR          NUMBER

Column Datatype Description
PADDR    RAW(4 | 8)   Address of the process state object
PSERIAL#   NUMBER     Process state object serial number
NAME     VARCHAR2(5) Name of this background process
DESCRIPTION VARCHAR2(64) Description of the background process
ERROR    NUMBER     Error encountered

通过观察paddr字段的值可以区分当前系统中是否启动对应的后台进程
如果当前系统中没有启动，则paddr值为00

rac系统中和单机相比会多出global相关的后台进程LMON、LMD0、LMS0等

SQL> select paddr,name,description,to_char(error) from v$bgprocess where paddr<>'00';

PADDR            NAME DESCRIPTION                                        TO_CHAR(ERROR)
---------------- ----- -------------------------------------------------- ----------------------------------------
00000007E0B868C0 PMON process cleanup                                    0
00000007DFB99218 DIAG diagnosibility process                             0
00000007E0B870A8 PSP0 process spawner 0                                  0
00000007DFB99A00 LMON global enqueue service monitor                     0
00000007E0B87890 LMD0 global enqueue service daemon 0                    0
00000007DFB9A1E8 LMS0 global cache service process 0                     0
00000007E0B88078 LMS1 global cache service process 1                     0
00000007DFB9A9D0 MMAN Memory Manager                                     0
00000007E0B88860 DBW0 db writer process 0                                0
00000007E0B8BFB8 ARC0 Archival Process 0                                 0
00000007DFB9E910 ARC1 Archival Process 1                                 0

PADDR            NAME DESCRIPTION                                        TO_CHAR(ERROR)
---------------- ----- -------------------------------------------------- ----------------------------------------
00000007DFB9B1B8 LGWR Redo etc.                                          0
00000007E0B8A800 LCK0 Lock Process 0                                     0
00000007E0B89048 CKPT checkpoint                                         0
00000007DFB9B9A0 SMON System Monitor Process                             0
00000007E0B89830 RECO distributed recovery                               0
00000007DFB9C188 CJQ0 Job Queue Coordinator                              0
00000007E0B8C7A0 QMNC AQ Coordinator                                     0
00000007DFB9D940 RBAL ASM Rebalance master                               0
00000007E0B8AFE8 ASMB ASM Background                                     0
00000007E0B8A018 MMON Manageability Monitor Process                      0
00000007DFB9C970 MMNL Manageability Monitor Process 2                    0

ITPub博客

v$bgprocess

最新文章