select t1.inst_id,t1.sid,t1.serial#,t1.username,t2.spid 系统进程id from gv$session t1
full join gv$process t2 on t2.addr=t1.paddr and t2.inst_id=t1.inst_id and (t2.BACKGROUND is null or background<>‘1‘)
原文：https://www.cnblogs.com/vanwoos/p/12593388.html