v$sessionとv$processの結合例

select s.username, s.process, s.program, p.spid, p.program from v$session s, v$process p where s.paddr = p.addr;