select pro.spid
from v$session ses,v$process pro
where ses.sid='15' and ses.paddr=pro.addr;
【Oracle】根据sid查询pid
于 2016-02-01 10:41:26 首次发布
select pro.spid
from v$session ses,v$process pro
where ses.sid='15' and ses.paddr=pro.addr;