select *
   from v$sqlarea a, v$session b
   where 1 = 1
   and a.sql_id = b.sql_id
   and status = 'ACTIVE';