PLAN

 SELECT ash.session_id, ash.session_serial#, ash.user_id, ash.program, ash.machine, 

       ash.sql_id, sql.sql_text, ash.event

FROM v$active_session_history ash

LEFT JOIN v$sql sql ON ash.sql_id = sql.sql_id

WHERE UPPER(sql.sql_text) LIKE '%%'

   OR UPPER(sql.sql_text) LIKE '%%'

  AND ash.sample_time BETWEEN SYSTIMESTAMP - INTERVAL '1' HOUR AND SYSTIMESTAMP

ORDER BY ash.sample_time DESC;