Try spid in v$process and join it to v$session using the addr-paddr columns.