col sid form 9999 col username form a10 col osuser form a10 col machine form a10 col program form a10 SELECT /*+ ORDERED */ s.sid, s.username, s.osuser, nvl(s.machine, '?') machine, nvl(s.program, '?') program, s.process F_Ground, p.spid B_Ground, x.sql_id, X.sql_text FROM sys.v_$session S, sys.v_$process P, sys.v_$sqlarea X WHERE s.sid like nvl('&sid','%') AND s.paddr = p.addr AND s.type != 'BACKGROUND' AND s.sql_address = x.address AND s.sql_hash_value = x.hash_value ORDER BY S.sid /