see_sql2.sql

COLUMN address NOPRINT
COLUMN username FORMAT a12
BREAK ON address SKIP 1
SELECT
   a.address
  ,sql_text
  ,osuser
  ,username
FROM
   v$sqltext a
  ,v$session s
WHERE s.SQL_ADDRESS = a.ADDRESS
  AND s.status = 'ACTIVE'
  AND s.type !='BACKGROUND'
ORDER BY
   a.ADDRESS
  ,a.piece;