SELECT s.sid,

          s.serial#,

          s.event,

          a.sql_text,

          a.sql_fulltext,

          s.username,

          s.status,

          s.machine,

          s.terminal,

          s.program,

          a.executions,

          s.sql_id,

          p.spid,

          a.direct_writes

     FROM (SELECT * FROM v$session WHERE status = 'ACTIVE') s

     LEFT JOIN v$sqlarea a

       ON s.sql_id = a.sql_id

    INNER JOIN v$process p

       ON s.paddr = p.addr