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