ITPub博客

首页 > Linux操作系统 > Linux操作系统 > v$bgprocess

v$bgprocess

原创 Linux操作系统 作者:安佰胜 时间:2011-10-08 11:19:57 0 删除 编辑

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博客 ” ,链接:http://blog.itpub.net/13177610/viewspace-708749/,如需转载,请注明出处,否则将追究法律责任。

下一篇: ora_rowscn
请登录后发表评论 登录
全部评论

注册时间:2009-08-26

  • 博文量
    215
  • 访问量
    627355