KSBDDIDN KSMFSNAM KSBDDDSC
---------- ---------- --------------------------------------------------
LMSz kjmlmsz_ global cache service process 35
LNS0 kcrrns0_ Network Server 0
LNS1 kcrrns1_ Network Server 1
LNS2 kcrrns2_ Network Server 2
LNS3 kcrrns3_ Network Server 3
LNS4 kcrrns4_ Network Server 4
LNS5 kcrrns5_ Network Server 5
LNS6 kcrrns6_ Network Server 6
LNS7 kcrrns7_ Network Server 7
LNS8 kcrrns8_ Network Server 8
LNS9 kcrrns9_ Network Server 9
KSBDDIDN KSMFSNAM KSBDDDSC
---------- ---------- --------------------------------------------------
LNSa kcrrns10_ Network Server 10
LNSb kcrrns11_ Network Server 11
LNSc kcrrns12_ Network Server 12
LNSd kcrrns13_ Network Server 13
LNSe kcrrns14_ Network Server 14
LNSf kcrrns15_ Network Server 15
LNSg kcrrns16_ Network Server 16
LNSh kcrrns17_ Network Server 17
LNSi kcrrns18_ Network Server 18
LNSj kcrrns19_ Network Server 19
LSP0 krvslsp_ Logical Standby
KSBDDIDN KSMFSNAM KSBDDDSC
---------- ---------- --------------------------------------------------
LSP1 krvsdbp_ Dictionary build process for Logical Standby
LSP2 krvssgsp_ Set Guard Standby Information for Logical Standby
MMAN kmgsdp_ Memory Manager
MMNL kebmmnl_ Manageability Monitor Process 2
MMON kebmmon_ Manageability Monitor Process
MRP0 krsmmrp_ Managed Standby Recovery
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
KSBDDIDN KSMFSNAM KSBDDDSC
---------- ---------- --------------------------------------------------
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
PMON ksuclp_ process cleanup
PSP0 kso_spawne process spawner 0
r0_
QMNC kwqmnc_ AQ Coordinator
RBAL kfgbrm_ ASM Rebalance master
KSBDDIDN KSMFSNAM KSBDDDSC
---------- ---------- --------------------------------------------------
RECO k2vbkg_ distributed recovery
RSM0 rfrmp0_ Data Guard Broker Resource Guard Process 0
RSM1 rfrmp1_ Data Guard Broker Resource Guard Process 1
RVWR krfwrp_ Recovery Writer
SMON ktmprc_ System Monitor Process
TEST ksbtstp_ test background process
158 rows selected.
进一步，我们可以通过以level 2 级别dump sga信息查看后台进程在内存中的地址
引用
SQL> ALTER SESSION SET EVENTS 'immediate trace name global_area level 2';
Session altered.
获取trc文件
引用
SQL> SELECT d.VALUE
2 || '/'
3 || LOWER (RTRIM (i.INSTANCE, CHR (0)))
4 || '_ora_'
5 || p.spid
6 || '.trc' trace_file_name
7 FROM (SELECT p.spid
8 FROM v$mystat m, v$session s, v$process p
WHERE m.statistic# = 1 AND s.SID = m.SID AND p.addr = s.paddr) p,
(SELECT t.INSTANCE
FROM v$thread t, v$parameter v
12 WHERE