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;

转载于:https://www.cnblogs.com/wujin/archive/2012/06/18/2553318.html