V$BGPROCESS displays information about the background processes.
| Column | Datatype | Description |
|
|
| Address of the process state object |
|
|
| Process state object serial number |
|
|
| Name of this background process |
|
|
| Description of the background process |
|
|
| Error encountered |
Example:
select * from V$BGPROCESS; --Oracle 10gR2ee
| PADDR | PSERIAL# | NAME | DESCRIPTION | ERROR |
| 00 | 0 | ARB0 | ASM Rebalance 0 | 0 |
| 00 | 0 | ARB1 | ASM Rebalance 1 | 0 |
| 00000007B772D4D0 | 1 | ARC0 | Archival Process 0 | 0 |
| 00000007BE71AC18 | 1 | ARC1 | Archival Process 1 | 0 |
| 00 | 0 | ASMB | ASM Background | 0 |
| 00000007B96EA648 | 1 | CJQ0 | Job Queue Coordinator | 0 |
| 00000007B86F0380 | 1 | CKPT | checkpoint | 0 |
| 00 | 0 | CTWR | Change Tracking Writer | 0 |
| 00000007B772BD18 | 1 | DBW0 | db writer process 0 | 0 |
| 00000007BE719460 | 1 | DBW1 | db writer process 1 | 0 |
| 00 | 0 | DBW2 | db writer process 2 | 0 |
| 00 | 0 | DIAG | diagnosibility process | 0 |
| 00 | 0 | DMON | DG Broker Monitor Process | 0 |
| 00 | 0 | EMN0 | Event Monitor Process 0 | 0 |
| 00 | 0 | FMON | File Mapping Monitor Process | 0 |
| 00 | 0 | GMON | diskgroup monitor | 0 |
| 00 | 0 | INSV | Data Guard Broker INstance SlaVe Process | 0 |
| 00 | 0 | LCK0 | Lock Process 0 | 0 |
| 00000007B96E9E60 | 1 | LGWR | Redo etc. | 0 |
| 00 | 0 | LMD0 | global enqueue service daemon 0 | 0 |
| 00 | 0 | LMON | global enqueue service monitor | 0 |
| 00 | 0 | LMS0 | global cache service process 0 | 0 |
| 00 | 0 | LNS0 | Network Server 0 | 0 |
| 00 | 0 | LNS1 | Network Server 1 | 0 |
| 00 | 0 | LSP0 | Logical Standby | 0 |
| 00 | 0 | LSP1 | Dictionary build process for Logical Standby | 0 |
| 00 | 0 | LSP2 | Set Guard Standby Information for Logical Standby | 0 |
| 00000007B86EFB98 | 1 | MMAN | Memory Manager | 0 |
| 00000007B772CCE8 | 1 | MMNL | Manageability Monitor Process 2 | 0 |
| 00000007B86F0B68 | 1 | MMON | Manageability Monitor Process | 0 |
| 00 | 0 | MRP0 | Managed Standby Recovery | 0 |
| 00 | 0 | NSV0 | Data Guard Broker NetSlave Process 0 | 0 |
| 00000007BE718C78 | 1 | PMON | process cleanup | 0 |
| 00000007B96E9678 | 1 | PSP0 | process spawner 0 | 0 |
| 00000007B86F2B08 | 3 | QMNC | AQ Coordinator | 0 |
| 00 | 0 | RBAL | ASM Rebalance master | 0 |
| 00000007BE719C48 | 1 | RECO | distributed recovery | 0 |
| 00 | 0 | RSM0 | Data Guard Broker Resource Guard Process 0 | 0 |
| 00 | 0 | RSM1 | Data Guard Broker Resource Guard Process 1 | 0 |
| 00 | 0 | RVWR | Recovery Writer | 0 |
| 00000007B772C500 | 1 | SMON | System Monitor Process | 0 |
No comments:
Post a Comment