OBTENER EL PID

select

’,’ || s.serial# "SID/SERIAL"
, s.username , s.osuser , p.spid "OS PID" , s.program
from v$session s , v$process p
Where s.paddr = p.addr and s.osuser=’jdpacor8’
order by to_number(p.spid) s.sid ||