List Background Processes
バックグランドプロセスのリストアップ
select * from v$bgprocess where paddr <> '00'
 
Example
  1* select * from v$bgprocess where paddr <> '00'
SQL> /
 
PADDR              PSERIAL# NAME  DESCRIPTION                                                                  ERROR
---------------- ---------- ----- ---------------------------------------------------------------- -----------------
00000000A51F2A38          1 PMON  process cleanup                                                  0
00000000A81C9CF0          1 PSP0  process spawner 0                                                0
00000000A51F3220          1 MMAN  Memory Manager                                                   0
00000000A81CA4D8          1 DBW0  db writer process 0                                              0
00000000A51F3A08          1 LGWR  Redo etc.                                                        0
00000000A81CACC0          1 CKPT  checkpoint                                                       0
00000000A51F41F0          1 SMON  System Monitor Process                                           0
00000000A81CB4A8          1 RECO  distributed recovery                                             0
00000000A51F49D8          1 CJQ0  Job Queue Coordinator                                            0
00000000A81CEC00          1 QMNC  AQ Coordinator                                                   0
00000000A81CBC90          1 MMON  Manageability Monitor Process                                    0
00000000A51F51C0          1 MMNL  Manageability Monitor Process 2                                  0

see also v$bgprocess