Sunday, May 22, 2011

Background Processes in 11gR2 RAC


SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
+ASM1


SQL> select inst_id,name,description from gv$bgprocess where paddr<>'00' order by inst_id, name;

INST_ID NAME DESCRIPTION
---------- ----- ----------------------------------------------------------------
1 ASMB ASM Background
1 CKPT checkpoint
1 DBW0 db writer process 0
1 DIA0 diagnosibility process 0
1 DIAG diagnosibility process
1 GEN0 generic0
1 GMON diskgroup monitor
1 LCK0 Lock Process 0
1 LGWR Redo etc.
1 LMD0 global enqueue service daemon 0
1 LMHB lm heartbeat monitor
1 LMON global enqueue service monitor
1 LMS0 global cache service process 0
1 MMAN Memory Manager
1 MMNL Manageability Monitor Process 2
1 MMON Manageability Monitor Process
1 PING interconnect latency measurement
1 PMON process cleanup
1 PSP0 process spawner 0
1 RBAL ASM Rebalance master
1 SMON System Monitor Process
1 VKTM Virtual Keeper of TiMe process
3 ASMB ASM Background
3 CKPT checkpoint
3 DBW0 db writer process 0
3 DIA0 diagnosibility process 0
3 DIAG diagnosibility process
3 GEN0 generic0
3 GMON diskgroup monitor
3 LCK0 Lock Process 0
3 LGWR Redo etc.
3 LMD0 global enqueue service daemon 0
3 LMHB lm heartbeat monitor
3 LMON global enqueue service monitor
3 LMS0 global cache service process 0
3 MMAN Memory Manager
3 MMNL Manageability Monitor Process 2
3 MMON Manageability Monitor Process
3 PING interconnect latency measurement
3 PMON process cleanup
3 PSP0 process spawner 0
3 RBAL ASM Rebalance master
3 SMON System Monitor Process
3 VKTM Virtual Keeper of TiMe process

44 rows selected.




SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
orcl1

SQL> select inst_id,name,description from gv$bgprocess where paddr<>'00' order by inst_id, name
2 /

INST_ID NAME DESCRIPTION
---------- ----- ----------------------------------------------------------------
1 ACMS Atomic Controlfile to Memory Server
1 ARC0 Archival Process 0
1 ARC1 Archival Process 1
1 ARC2 Archival Process 2
1 ARC3 Archival Process 3
1 ASMB ASM Background
1 CJQ0 Job Queue Coordinator
1 CKPT checkpoint
1 DBRM DataBase Resource Manager
1 DBW0 db writer process 0
1 DIA0 diagnosibility process 0
1 DIAG diagnosibility process
1 GEN0 generic0
1 GTX0 Global Txn process 0
1 LCK0 Lock Process 0
1 LGWR Redo etc.
1 LMD0 global enqueue service daemon 0
1 LMHB lm heartbeat monitor
1 LMON global enqueue service monitor
1 LMS0 global cache service process 0
1 MARK mark AU for resync koordinator
1 MMAN Memory Manager
1 MMNL Manageability Monitor Process 2
1 MMON Manageability Monitor Process
1 PING interconnect latency measurement
1 PMON process cleanup
1 PSP0 process spawner 0
1 QMNC AQ Coordinator
1 RBAL ASM Rebalance master
1 RCBG Result Cache: Background
1 RECO distributed recovery
1 RMS0 rac management server
1 RSMN Remote Slave Monitor
1 SMCO Space Manager Process
1 SMON System Monitor Process
1 VKRM Virtual sKeduler for Resource Manager
1 VKTM Virtual Keeper of TiMe process
3 ACMS Atomic Controlfile to Memory Server
3 ARC0 Archival Process 0
3 ARC1 Archival Process 1
3 ARC2 Archival Process 2
3 ARC3 Archival Process 3
3 ASMB ASM Background
3 CJQ0 Job Queue Coordinator
3 CKPT checkpoint
3 DBRM DataBase Resource Manager
3 DBW0 db writer process 0
3 DIA0 diagnosibility process 0
3 DIAG diagnosibility process
3 GEN0 generic0
3 GTX0 Global Txn process 0
3 LCK0 Lock Process 0
3 LGWR Redo etc.
3 LMD0 global enqueue service daemon 0
3 LMHB lm heartbeat monitor
3 LMON global enqueue service monitor
3 LMS0 global cache service process 0
3 MARK mark AU for resync koordinator
3 MMAN Memory Manager
3 MMNL Manageability Monitor Process 2
3 MMON Manageability Monitor Process
3 PING interconnect latency measurement
3 PMON process cleanup
3 PSP0 process spawner 0
3 QMNC AQ Coordinator
3 RBAL ASM Rebalance master
3 RCBG Result Cache: Background
3 RECO distributed recovery
3 RMS0 rac management server
3 RSMN Remote Slave Monitor
3 SMCO Space Manager Process
3 SMON System Monitor Process
3 VKRM Virtual sKeduler for Resource Manager
3 VKTM Virtual Keeper of TiMe process

74 rows selected.