COLUMN paddr NOPRINT NEW_VALUE vpaddr
SELECT paddr FROM v$session WHERE sid = &1;

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

select addr,spid from v$process where addr = '&vpaddr';

undefine vpaddr