18c 19c 기동시 백그라운드 프로세스 비교

v$bgprocess를 각각의 상태에서 비교하였습니다.

 

18c

No Mount

Open

PADDR            NAME            DESCRIPTION ---------------- --------------- ---------------------------------------- 000000006A9E3848 CKPT            checkpoint 000000006A9CFDD8 CLMN            process cleanup 000000006A9EE6F8 D000            Dispatchers 000000006A9DBE00 DBRM            DataBase Resource Manager 000000006A9E1558 DBW0            db writer process 0 000000006A9E03E0 DIA0            diagnosibility process 0 000000006A9D8998 DIAG            diagnosibility process 000000006A9EE6F8 FENC            IOServer fence monitor 000000006A9D3240 GEN0            generic0 000000006A9D66A8 GEN1            generic1 000000006A9E49C0 LG00            Log Writer Slave 000000006A9E6CB0 LG01            Log Writer Slave 000000006A9E26D0 LGWR            Redo etc. 000000006A9EB290 LREG            Listener Registration 000000006A9F3E50 M000            MMON slave class 1 000000006A9F4FC8 M001            MMON slave class 1 000000006A9D43B8 MMAN            Memory Manager 000000006A9D5530 MMNL            Manageability Monitor Process 2 000000006A9EF870 MMON            Manageability Monitor Process 000000006A9D9B10 OFSD            Oracle File Server BG 000000006A9DF268 PMAN            process manager 000000006A9CEC60 PMON            process cleanup 000000006A9D0F50 PSP0            process spawner 0 000000006A9ED580 PXMN            PX Monitor 000000006A9E8FA0 RECO            distributed recovery 000000006A9F09E8 S000            Shared servers 000000006A9DAC88 SCMN 000000006A9D7820 SCMN 000000006A9E7E28 SMCO            Space Manager Process 000000006A9E5B38 SMON            System Monitor Process 000000006A9DE0F0 SVCB            services background monitor 000000006A9F1B60 TMON            Transport Monitor 000000006A9DCF78 VKRM            Virtual sKeduler for Resource Manager 000000006A9D20C8 VKTM            Virtual Keeper of TiMe process 000000006A9EA118 W000            space management slave pool 000000006A9EC408 W001            space management slave pool   36 rows selected.

PADDR            NAME  DESCRIPTION ---------------- ----- ---------------------------------------- 000000006A9F95A8 AQPC  AQ Process Coord 000000006A9FA720 CJQ0  Job Queue Coordinator 000000006A9E3848 CKPT  checkpoint 000000006A9CFDD8 CLMN  process cleanup 000000006A9EE6F8 D000  Dispatchers 000000006A9DBE00 DBRM  DataBase Resource Manager 000000006A9E1558 DBW0  db writer process 0 000000006A9E03E0 DIA0  diagnosibility process 0 000000006A9D8998 DIAG  diagnosibility process 000000006A9EE6F8 FENC  IOServer fence monitor 000000006A9D3240 GEN0  generic0 000000006A9D66A8 GEN1  generic1 000000006A9E49C0 LG00  Log Writer Slave 000000006A9E6CB0 LG01  Log Writer Slave 000000006A9E26D0 LGWR  Redo etc. 000000006A9EB290 LREG  Listener Registration 000000006A9F3E50 M000  MMON slave class 1 000000006A9F4FC8 M001  MMON slave class 1 000000006AA09BB0 M002  MMON slave class 1 000000006A9D43B8 MMAN  Memory Manager 000000006A9D5530 MMNL  Manageability Monitor Process 2 000000006A9EF870 MMON  Manageability Monitor Process 000000006A9D9B10 OFSD  Oracle File Server BG 000000006A9FCA10 P000  Parallel query slave 000000006A9FDB88 P001  Parallel query slave 000000006A9FED00 P002  Parallel query slave 000000006A9FFE78 P003  Parallel query slave 000000006A9DF268 PMAN  process manager 000000006A9CEC60 PMON  process cleanup 000000006A9D0F50 PSP0  process spawner 0 000000006A9ED580 PXMN  PX Monitor 000000006AA06748 Q002  QMON MS 000000006AA078C0 Q003  QMON MS 000000006AA04458 QM02  QMON MS 000000006AA055D0 QM03  QMON MS 000000006A9E8FA0 RECO  distributed recovery 000000006A9F09E8 S000  Shared servers 000000006AA02168 S001  Shared servers 000000006A9D7820 SCMN 000000006A9DAC88 SCMN 000000006A9E7E28 SMCO  Space Manager Process 000000006A9E5B38 SMON  System Monitor Process 000000006A9DE0F0 SVCB  services background monitor 000000006A9F1B60 TMON  Transport Monitor 000000006A9F6140 TT00  Redo Transport 000000006A9F72B8 TT01  Redo Transport 000000006A9F8430 TT02  Redo Transport 000000006A9DCF78 VKRM  Virtual sKeduler for Resource Manager 000000006A9D20C8 VKTM  Virtual Keeper of TiMe process 000000006A9EA118 W000  space management slave pool 000000006A9EC408 W001  space management slave pool 000000006A9FB898 W002  space management slave pool 000000006AA00FF0 W003  space management slave pool 000000006AA032E0 W004  space management slave pool   54 rows selected.

 

19c

No Mount

Open

PADDR            NAME            DESCRIPTION ---------------- --------------- ---------------------------------------- 000000007171F218 CKPT            checkpoint 0000000071707158 CLMN            process cleanup 000000007172C7D8 D000            Dispatchers 0000000071715C78 DBRM            DataBase Resource Manager 000000007171C758 DBW0            db writer process 0 000000007171B1F8 DIA0            diagnosibility process 0 0000000071711C58 DIAG            diagnosibility process 000000007172C7D8 FENC            IOServer fence monitor 000000007170B178 GEN0            generic0 000000007170F198 GEN1            generic1 0000000071720778 LG00            Log Writer Slave 0000000071723238 LG01            Log Writer Slave 000000007171DCB8 LGWR            Redo etc. 00000000717287B8 LREG            Listener Registration 00000000717332B8 M000            MMON slave class 1 000000007170C6D8 MMAN            Memory Manager 000000007172DD38 MMNL            Manageability Monitor Process 000000007170DC38 MMON            Manageability Monitor Process 00000000717131B8 OFSD            Oracle File Server BG 0000000071719C98 PMAN            process manager 0000000071705BF8 PMON            process cleanup 00000000717086B8 PSP0            process spawner 0 000000007172B278 PXMN            PX Monitor 0000000071725CF8 RECO            distributed recovery 000000007172F298 S000            Shared servers 00000000717106F8 SCMN 0000000071714718 SCMN 0000000071724798 SMCO            Space Manager Process 0000000071721CD8 SMON            System Monitor Process 0000000071718738 SVCB            services background monitor 00000000717307F8 TMON            Transport Monitor 00000000717171D8 VKRM            Virtual sKeduler for Resource Manager 0000000071709C18 VKTM            Virtual Keeper of TiMe process 0000000071727258 W000            space management slave pool 0000000071729D18 W001            space management slave pool   35 rows selected.

PADDR            NAME  DESCRIPTION ---------------- ----- ---------------------------------------- 0000000071738838 AQPC  AQ Process Coord 0000000071739D98 CJQ0  Job Queue Coordinator 000000007171F218 CKPT  checkpoint 0000000071707158 CLMN  process cleanup 000000007172C7D8 D000  Dispatchers 0000000071715C78 DBRM  DataBase Resource Manager 000000007171C758 DBW0  db writer process 0 000000007171B1F8 DIA0  diagnosibility process 0 0000000071711C58 DIAG  diagnosibility process 000000007172C7D8 FENC  IOServer fence monitor 000000007170B178 GEN0  generic0 000000007170F198 GEN1  generic1 0000000071720778 LG00  Log Writer Slave 0000000071723238 LG01  Log Writer Slave 000000007171DCB8 LGWR  Redo etc. 00000000717287B8 LREG  Listener Registration 00000000717332B8 M000  MMON slave class 1 0000000071744898 M001  MMON slave class 1 0000000071745DF8 M002  MMON slave class 1 000000007174B378 M003  MMON slave class 1 000000007170C6D8 MMAN  Memory Manager 000000007172DD38 MMNL  Manageability Monitor Process 2 000000007170DC38 MMON  Manageability Monitor Process 00000000717131B8 OFSD  Oracle File Server BG 000000007173C858 P000  Parallel query slave 000000007173DDB8 P001  Parallel query slave 000000007173F318 P002  Parallel query slave 0000000071740878 P003  Parallel query slave 0000000071719C98 PMAN  process manager 0000000071705BF8 PMON  process cleanup 00000000717086B8 PSP0  process spawner 0 000000007172B278 PXMN  PX Monitor 0000000071034028 Q002  QMON MS 0000000071035588 Q003  QMON MS 00000000717488B8 QM02  QMON MS 0000000071725CF8 RECO  distributed recovery 000000007172F298 S000  Shared servers 00000000717106F8 SCMN 0000000071714718 SCMN 0000000071724798 SMCO  Space Manager Process 0000000071721CD8 SMON  System Monitor Process 0000000071718738 SVCB  services background monitor 00000000717307F8 TMON  Transport Monitor 0000000071734818 TT00  Redo Transport 0000000071735D78 TT01  Redo Transport 00000000717372D8 TT02  Redo Transport 00000000717171D8 VKRM  Virtual sKeduler for Resource Manager 0000000071709C18 VKTM  Virtual Keeper of TiMe process 0000000071727258 W000  space management slave pool 0000000071729D18 W001  space management slave pool 000000007173B2F8 W002  space management slave pool 0000000071741DD8 W003  space management slave pool 0000000071747358 W004  space management slave pool   53 rows selected.