2017. 1. 4. 15:21 오라클
오라클 Backgroud Process 확인하는 쿼리
ora_nsa2 Process 에 대해서 찾아보다가..Online redo log를 standby server 로 전송하는 역할이고..
오라클의 X$ 뷰를 통해서 Background 프로세스의 이름 및 용도를 확인하는 방법까지..
11.2.0.4 기준 (297개 확인가능, 내가 만든 TEST instance 포함)
--------------------------------------------------------------------------------
set lines 120
column EXTERNAL_NAME format a13
column INTERNAL_NAME format a13
column DESCRIPTION format a50
SELECT x$ksbdd.ksbddidn AS external_name,
x$ksmfsv.ksmfsnam AS internal_name, x$ksbdd.ksbdddsc AS description
FROM x$ksbdd, x$ksbdp, x$ksmfsv
WHERE x$ksbdd.indx = x$ksbdp.indx AND x$ksbdp.addr = x$ksmfsv.ksmfsadr
ORDER BY 1;
EXTERNAL_NAME INTERNAL_NAME DESCRIPTION
------------- ------------- --------------------------------------------------
ABMR krbabrBgProc_ Auto BMR Background Process
ACFS kfofsbg_ ACFS CSS
ACMS ksacms_ Atomic Controlfile to Memory Server
ARB0 kfgbr0_ ASM Rebalance 0
ARB1 kfgbr1_ ASM Rebalance 1
ARB2 kfgbr2_ ASM Rebalance 2
ARB3 kfgbr3_ ASM Rebalance 3
ARB4 kfgbr4_ ASM Rebalance 4
ARB5 kfgbr5_ ASM Rebalance 5
ARB6 kfgbr6_ ASM Rebalance 6
ARB7 kfgbr7_ ASM Rebalance 7
ARB8 kfgbr8_ ASM Rebalance 8
ARB9 kfgbr9_ ASM Rebalance 9
ARBA kfgbrA_ ASM Rebalance 10
ARC0 kcrrd0_ Archival Process 0
ARC1 kcrrd1_ Archival Process 1
ARC2 kcrrd2_ Archival Process 2
ARC3 kcrrd3_ Archival Process 3
ARC4 kcrrd4_ Archival Process 4
ARC5 kcrrd5_ Archival Process 5
ARC6 kcrrd6_ Archival Process 6
ARC7 kcrrd7_ Archival Process 7
ARC8 kcrrd8_ Archival Process 8
ARC9 kcrrd9_ Archival Process 9
ARCa kcrrdxa_ Archival Process 10
ARCb kcrrdxb_ Archival Process 11
ARCc kcrrdxc_ Archival Process 12
ARCd kcrrdxd_ Archival Process 13
ARCe kcrrdxe_ Archival Process 14
ARCf kcrrdxf_ Archival Process 15
ARCg kcrrdxg_ Archival Process 16
ARCh kcrrdxh_ Archival Process 17
ARCi kcrrdxi_ Archival Process 18
ARCj kcrrdxj_ Archival Process 19
ARCk kcrrdxk_ Archival Process 20
ARCl kcrrdxl_ Archival Process 21
ARCm kcrrdxm_ Archival Process 22
ARCn kcrrdxn_ Archival Process 23
ARCo kcrrdxo_ Archival Process 24
ARCp kcrrdxp_ Archival Process 25
ARCq kcrrdxq_ Archival Process 26
ARCr kcrrdxr_ Archival Process 27
ARCs kcrrdxs_ Archival Process 28
ARCt kcrrdxt_ Archival Process 29
ASMB kfnbgd_ ASM Background
CJQ0 kkjcjq0_ Job Queue Coordinator
CKPT kcvcdp_ checkpoint
CTWR krcbgp_ Change Tracking Writer
DBRM kskdbrm_ DataBase Resource Manager
DBW0 kcbdw0_ db writer process 0
DBW1 kcbdw1_ db writer process 1
DBW2 kcbdw2_ db writer process 2
DBW3 kcbdw3_ db writer process 3
DBW4 kcbdw4_ db writer process 4
DBW5 kcbdw5_ db writer process 5
DBW6 kcbdw6_ db writer process 6
DBW7 kcbdw7_ db writer process 7
DBW8 kcbdw8_ db writer process 8
DBW9 kcbdw9_ db writer process 9
DBWa kcbdw10_ db writer process 10 (a)
DBWb kcbdw11_ db writer process 11 (b)
DBWc kcbdw12_ db writer process 12 (c)
DBWd kcbdw13_ db writer process 13 (d)
DBWe kcbdw14_ db writer process 14 (e)
DBWf kcbdw15_ db writer process 15 (f)
DBWg kcbdw16_ db writer process 16 (g)
DBWh kcbdw17_ db writer process 17 (h)
DBWi kcbdw18_ db writer process 18 (i)
DBWj kcbdw19_ db writer process 19 (j)
DBWk kcbdw20_ db writer process 20 (k)
DBWl kcbdw21_ db writer process 21 (l)
DBWm kcbdw22_ db writer process 22 (m)
DBWn kcbdw23_ db writer process 23 (n)
DBWo kcbdw24_ db writer process 24 (o)
DBWp kcbdw25_ db writer process 25 (p)
DBWq kcbdw26_ db writer process 26 (q)
DBWr kcbdw27_ db writer process 27 (r)
DBWs kcbdw28_ db writer process 28 (s)
DBWt kcbdw29_ db writer process 29 (t)
DBWu kcbdw30_ db writer process 30 (u)
DBWv kcbdw31_ db writer process 31 (v)
DBWw kcbdw32_ db writer process 32 (w)
DBWx kcbdw33_ db writer process 33 (x)
DBWy kcbdw34_ db writer process 34 (y)
DBWz kcbdw35_ db writer process 35 (z)
DIA0 kjzdtp0_ diagnosibility process 0
DIA1 kjzdtp1_ diagnosibility process 1
DIA2 kjzdtp2_ diagnosibility process 2
DIA3 kjzdtp3_ diagnosibility process 3
DIA4 kjzdtp4_ diagnosibility process 4
DIA5 kjzdtp5_ diagnosibility process 5
DIA6 kjzdtp6_ diagnosibility process 6
DIA7 kjzdtp7_ diagnosibility process 7
DIA8 kjzdtp8_ diagnosibility process 8
DIA9 kjzdtp9_ diagnosibility process 9
DIAG kstdtp_ diagnosibility process
DMON rfm_dmon_proc DG Broker Monitor Process
_
DSKM kszdskmp_ slave DiSKMon process
EMNC kponc_ EMON Coordinator
FBDA ktfaarch_ Flashback Data Archiver Process
FMON ksfmfmon_ File Mapping Monitor Process
FSFP rfi_fsfp_ Data Guard Broker FSFO Pinger
GEN0 ksbgen0_ generic0
GMON kfdp_gmon_ diskgroup monitor
GTX0 k2qgtx0_ Global Txn process 0
GTX1 k2qgtx1_ Global Txn process 1
GTX2 k2qgtx2_ Global Txn process 2
GTX3 k2qgtx3_ Global Txn process 3
GTX4 k2qgtx4_ Global Txn process 4
GTX5 k2qgtx5_ Global Txn process 5
GTX6 k2qgtx6_ Global Txn process 6
GTX7 k2qgtx7_ Global Txn process 7
GTX8 k2qgtx8_ Global Txn process 8
GTX9 k2qgtx9_ Global Txn process 9
GTXa k2qgtx10_ Global Txn process 10
GTXb k2qgtx11_ Global Txn process 11
GTXc k2qgtx12_ Global Txn process 12
GTXd k2qgtx13_ Global Txn process 13
GTXe k2qgtx14_ Global Txn process 14
GTXf k2qgtx15_ Global Txn process 15
GTXg k2qgtx16_ Global Txn process 16
GTXh k2qgtx17_ Global Txn process 17
GTXi k2qgtx18_ Global Txn process 18
GTXj k2qgtx19_ Global Txn process 19
INSV rfi_insv_ Data Guard Broker INstance SlaVe Process
LCK0 kclck0_ Lock Process 0
LGWR kcrprc_ Redo etc.
LMD0 kjid0_ global enqueue service daemon 0
LMHB kjfmhdm_ lm heartbeat monitor
LMON kjidm_ global enqueue service monitor
LMS0 kjmlms0_ global cache service process 0
LMS1 kjmlms1_ global cache service process 1
LMS2 kjmlms2_ global cache service process 2
LMS3 kjmlms3_ global cache service process 3
LMS4 kjmlms4_ global cache service process 4
LMS5 kjmlms5_ global cache service process 5
LMS6 kjmlms6_ global cache service process 6
LMS7 kjmlms7_ global cache service process 7
LMS8 kjmlms8_ global cache service process 8
LMS9 kjmlms9_ global cache service process 9
LMSa kjmlmsa_ global cache service process 10
LMSb kjmlmsb_ global cache service process 11
LMSc kjmlmsc_ global cache service process 12
LMSd kjmlmsd_ global cache service process 13
LMSe kjmlmse_ global cache service process 14
LMSf kjmlmsf_ global cache service process 15
LMSg kjmlmsg_ global cache service process 16
LMSh kjmlmsh_ global cache service process 17
LMSi kjmlmsi_ global cache service process 18
LMSj kjmlmsj_ global cache service process 19
LMSk kjmlmsk_ global cache service process 20
LMSl kjmlmsl_ global cache service process 21
LMSm kjmlmsm_ global cache service process 22
LMSn kjmlmsn_ global cache service process 23
LMSo kjmlmso_ global cache service process 24
LMSp kjmlmsp_ global cache service process 25
LMSq kjmlmsq_ global cache service process 26
LMSr kjmlmsr_ global cache service process 27
LMSs kjmlmss_ global cache service process 28
LMSt kjmlmst_ global cache service process 29
LMSu kjmlmsu_ global cache service process 30
LMSv kjmlmsv_ global cache service process 31
LMSw kjmlmsw_ global cache service process 32
LMSx kjmlmsx_ global cache service process 33
LMSy kjmlmsy_ global cache service process 34
LSP0 dgllsp_ Logical Standby
LSP1 dgldbp_ Dictionary build process for Logical Standby
LSP2 dglsgsp_ Set Guard Standby Information for Logical Standby
MARK kfioSr_markp_ mark AU for resync koordinator
MMAN kmgsdp_ Memory Manager
MMNL kebmmnl_ Manageability Monitor Process 2
MMON kebmmon_ Manageability Monitor Process
MRP0 krsmmrp_ Managed Standby Recovery
NSA1 krswnsa1_ Redo transport NSA1
NSA2 krswnsa2_ Redo transport NSA2
NSA3 krswnsa3_ Redo transport NSA3
NSA4 krswnsa4_ Redo transport NSA4
NSA5 krswnsa5_ Redo transport NSA5
NSA6 krswnsa6_ Redo transport NSA6
NSA7 krswnsa7_ Redo transport NSA7
NSA8 krswnsa8_ Redo transport NSA8
NSA9 krswnsa9_ Redo transport NSA9
NSAA krswnsa10_ Redo transport NSAA
NSAB krswnsa11_ Redo transport NSAB
NSAC krswnsa12_ Redo transport NSAC
NSAD krswnsa13_ Redo transport NSAD
NSAE krswnsa14_ Redo transport NSAE
NSAF krswnsa15_ Redo transport NSAF
NSAG krswnsa16_ Redo transport NSAG
NSAH krswnsa17_ Redo transport NSAH
NSAI krswnsa18_ Redo transport NSAI
NSAJ krswnsa19_ Redo transport NSAJ
NSAK krswnsa20_ Redo transport NSAK
NSAL krswnsa21_ Redo transport NSAL
NSAM krswnsa22_ Redo transport NSAM
NSAN krswnsa23_ Redo transport NSAN
NSAO krswnsa24_ Redo transport NSAO
NSAP krswnsa25_ Redo transport NSAP
NSAQ krswnsa26_ Redo transport NSAQ
NSAR krswnsa27_ Redo transport NSAR
NSAS krswnsa28_ Redo transport NSAS
NSAT krswnsa29_ Redo transport NSAT
NSAU krswnsa30_ Redo transport NSAU
NSAV krswnsa31_ Redo transport NSAV
NSS1 krswnss1_ Redo transport NSS1
NSS2 krswnss2_ Redo transport NSS2
NSS3 krswnss3_ Redo transport NSS3
NSS4 krswnss4_ Redo transport NSS4
NSS5 krswnss5_ Redo transport NSS5
NSS6 krswnss6_ Redo transport NSS6
NSS7 krswnss7_ Redo transport NSS7
NSS8 krswnss8_ Redo transport NSS8
NSS9 krswnss9_ Redo transport NSS9
NSSA krswnss10_ Redo transport NSSA
NSSB krswnss11_ Redo transport NSSB
NSSC krswnss12_ Redo transport NSSC
NSSD krswnss13_ Redo transport NSSD
NSSE krswnss14_ Redo transport NSSE
NSSF krswnss15_ Redo transport NSSF
NSSG krswnss16_ Redo transport NSSG
NSSH krswnss17_ Redo transport NSSH
NSSI krswnss18_ Redo transport NSSI
NSSJ krswnss19_ Redo transport NSSJ
NSSK krswnss20_ Redo transport NSSK
NSSL krswnss21_ Redo transport NSSL
NSSM krswnss22_ Redo transport NSSM
NSSN krswnss23_ Redo transport NSSN
NSSO krswnss24_ Redo transport NSSO
NSSP krswnss25_ Redo transport NSSP
NSSQ krswnss26_ Redo transport NSSQ
NSSR krswnss27_ Redo transport NSSR
NSSS krswnss28_ Redo transport NSSS
NSST krswnss29_ Redo transport NSST
NSSU krswnss30_ Redo transport NSSU
NSSV krswnss31_ Redo transport NSSV
NSV0 rfins0_ Data Guard Broker NetSlave Process 0
NSV1 rfins1_ Data Guard Broker NetSlave Process 1
NSV2 rfins2_ Data Guard Broker NetSlave Process 2
NSV3 rfins3_ Data Guard Broker NetSlave Process 3
NSV4 rfins4_ Data Guard Broker NetSlave Process 4
NSV5 rfins5_ Data Guard Broker NetSlave Process 5
NSV6 rfins6_ Data Guard Broker NetSlave Process 6
NSV7 rfins7_ Data Guard Broker NetSlave Process 7
NSV8 rfins8_ Data Guard Broker NetSlave Process 8
NSV9 rfins9_ Data Guard Broker NetSlave Process 9
NSVA rfinsa_ Data Guard Broker NetSlave Process A
NSVB rfinsb_ Data Guard Broker NetSlave Process B
NSVC rfinsc_ Data Guard Broker NetSlave Process C
NSVD rfinsd_ Data Guard Broker NetSlave Process D
NSVE rfinse_ Data Guard Broker NetSlave Process E
NSVF rfinsf_ Data Guard Broker NetSlave Process F
NSVG rfinsg_ Data Guard Broker NetSlave Process G
NSVH rfinsh_ Data Guard Broker NetSlave Process H
NSVI rfinsi_ Data Guard Broker NetSlave Process I
NSVJ rfinsj_ Data Guard Broker NetSlave Process J
NSVK rfinsk_ Data Guard Broker NetSlave Process K
NSVL rfinsl_ Data Guard Broker NetSlave Process L
NSVM rfinsm_ Data Guard Broker NetSlave Process M
NSVN rfinsn_ Data Guard Broker NetSlave Process N
NSVO rfinso_ Data Guard Broker NetSlave Process O
NSVP rfinsp_ Data Guard Broker NetSlave Process P
NSVQ rfinsq_ Data Guard Broker NetSlave Process Q
NSVR rfinsr_ Data Guard Broker NetSlave Process R
NSVS rfinss_ Data Guard Broker NetSlave Process S
NSVT rfinst_ Data Guard Broker NetSlave Process T
NSVU rfinsu_ Data Guard Broker NetSlave Process U
PING ksxp_ping_ interconnect latency measurement
PMON ksuclp_ process cleanup
PSP0 kso_spawner0_ process spawner 0
QMNC kwqmnc_ AQ Coordinator
RBAL kfgbrm_ ASM Rebalance master
RCBG qesrcbg_ Result Cache: Background
RECO k2vbkg_ distributed recovery
RMS0 kjmrms0_ rac management server
RPOP ksfdss_repop_ instant restore repopulation daemon
RSM0 rfrmp0_ Data Guard Broker Resource Guard Process 0
RSMN ksvrrp_ Remote Slave Monitor
RVWR krfwrp_ Recovery Writer
SMCO ktsjsmco_ Space Manager Process
SMON ktmprc_ System Monitor Process
TEST ksbtstp_ test background process
VBG0 kfvbg0_ Volume BG 0
VBG1 kfvbg1_ Volume BG 1
VBG2 kfvbg2_ Volume BG 2
VBG3 kfvbg3_ Volume BG 3
VBG4 kfvbg4_ Volume BG 4
VBG5 kfvbg5_ Volume BG 5
VBG6 kfvbg6_ Volume BG 6
VBG7 kfvbg7_ Volume BG 7
VBG8 kfvbg8_ Volume BG 8
VBG9 kfvbg9_ Volume BG 9
VDBG kfvdbg_ Volume Driver BG
VKRM kskvkrm_ Virtual sKeduler for Resource Manager
VKTM kstmvktm_ Virtual Keeper of TiMe process
VMB0 kfvmb0_ Volume Membership 0
XDMG kxdam_mgr_ cell automation manager
XDWK kxdam_slvbg_ cell automation worker actions
297 rows selected.
