分类：
2012-06-13 22:14:27
原文地址：查看Oracle的核心进程 作者：zrp999
查看Oracle的核心进程
select vb.name NOME, vp.program PROCESSNAME, vp.spid THREADID, vs.sid SID from v$session vs, v$process vp, v$bgprocess vb Where vb.paddr <> '00' and vb.paddr = vp.addr and vp.addr = vs.paddr;
NOME PROCESSNAME THREADID SID
----- ------------------------------------------------ ------------ ----------
PMON oracle@bjhealth1 (PMON) 4572 170
DIAG oracle@bjhealth1 (DIAG) 4574 169
PSP0 oracle@bjhealth1 (PSP0) 4576 168
LMON oracle@bjhealth1 (LMON) 4578 167
LMD0 oracle@bjhealth1 (LMD0) 4580 166
LMS0 oracle@bjhealth1 (LMS0) 4582 165
MMAN oracle@bjhealth1 (MMAN) 4592 164
DBW0 oracle@bjhealth1 (DBW0) 4594 163
LGWR oracle@bjhealth1 (LGWR) 4596 161
CKPT oracle@bjhealth1 (CKPT) 4598 160
SMON oracle@bjhealth1 (SMON) 4602 159
RECO oracle@bjhealth1 (RECO) 4605 158
CJQ0 oracle@bjhealth1 (CJQ0) 4608 157
MMON oracle@bjhealth1 (MMON) 4611 156
MMNL oracle@bjhealth1 (MMNL) 4626 155
LCK0 oracle@bjhealth1 (LCK0) 4639 154
QMNC oracle@bjhealth1 (QMNC) 4873 150
SELECT spid, osuser, s.program,sid FROM v$process p, v$session s WHERE p.addr=s.paddr;
SELECT spid, osuser, s.program,sid FROM v$process p, v$session s WHERE p.addr=s.paddr and s.program like 'racgimon%'
