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
/