【Oracle】根据sid查询pid

select pro.spid 
from v$session ses,v$process pro 
where ses.sid='15' and ses.paddr=pro.addr;