Select a.program,b.spid,c.sql_text From v$session a, v$process b, v$sqlarea c Where a.paddr = b.addr And a.sql_hash_value = c.hash_value And a.username is not null;