Saturday, October 7, 2023

Oracle 23c new feature: default running background processes

 select distinct name,description,

  json_value(attributes,'$.instance_critical' returning varchar) critical,
  json_value(attributes,'$.restartable' returning varchar) restartable,
  json_value(attributes,'$.worker' returning varchar) worker
from v$bgprocess where paddr<>'00' order by name;
NAMEDESCRIPTIONCRITICALRESTARTABLEWORKER
AQPCAQ Process Coordnonono
BG00Testing SRV processnonoyes
BG01Testing SRV processnonoyes
BG02Testing SRV process3nonoyes
CJQ0Job Queue Coordinatornoyesno
CKPTcheckpointyesnono
CL00process cleanup slaveyesnoyes
CLMNprocess cleanupyesnono
D000Dispatchersnonoyes
DBRMDataBase Resource Manageryesnono
DBW0db writer process 0yesnono
DIA0diagnosibility process 0noyesno
DIA1Deadlock Detectionnoyesno
DIAGdiagnosibility processnoyesno
FENCIOServer fence monitoryesnono
GCR0GCR Helpers (LMHB)nonoyes
GCW0GCR Monitor processes (LMHB)nonoyes
GEN0generic0yesnono
GEN2generic2yesnono
LGWRRedo etc.yesnono
LMHBlm heartbeat monitornoyesno
LREGListener Registrationyesnono
M000MMON slave class 1nonoyes
M001MMON slave class 1nonoyes
M002MMON slave class 1nonoyes
M003MMON slave class 1nonoyes
M005MMON slave class 1nonoyes
M006MMON slave class 1nonoyes
M007MMON slave class 1nonoyes
M008MMON slave class 1nonoyes
M009MMON slave class 1nonoyes
MMANMemory Manageryesnono
MMNLManageability Monitor Process 2noyesno
MMONManageability Monitor Processnoyesno
OFSDOracle File Server BGnoyesno
PMANprocess manageryesnono
PMONprocess cleanupyesnono
PSP0process spawner 0yesnono
PXMNPX Monitornoyesno
Q003QMON MSnonoyes
Q004QMON MSnonoyes
QM02QMON MSnonoyes
RCBGResult Cache: Backgroundnonono
RECOdistributed recoverynoyesno
S000Shared serversnonoyes
SCMNnonoyes
SMCOSpace Manager Processnoyesno
SMONSystem Monitor Processyesnono
SVCBservices background monitornoyesno
TMONTransport Monitornonono
TT00Redo Transportnonoyes
TT01Redo Transportnonoyes
VKRMVirtual sKeduler for Resource Managernoyesno
VKTMVirtual Keeper of TiMe processyesnono
VOSDVOS Daemonyesnono
W000space management slave poolnonoyes
W001space management slave poolnonoyes

No comments:

Post a Comment