COLUMN addr NOPRINT NEW_VALUE vpaddr
COLUMN sid NOPRINT NEW_VALUE vsid

select addr from v$process where spid = &1;

--SELECT sid,serial#,paddr,program,logon_time FROM v$session WHERE paddr = '&vpaddr';

SELECT sid FROM v$session WHERE paddr = '&vpaddr';

@sid3 &vsid

undefine vpaddr
undefine vsid