select * from v$process a,v$session b, v$sqlarea c where a.addr=b.PADDR and b.SQL_HASH_VALUE=c.HASH_VALUE