Oracle查询会话对应的系统进程id的sql
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')
啦啦啦！！！
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')
