Top 5 SQL statements in the past one hour

select * from (

select active_session_history.sql_id,

 dba_users.username,

 sqlarea.sql_text,

sum(active_session_history.wait_time +

active_session_history.time_waited) ttl_wait_time

from v$active_session_history active_session_history,

v$sqlarea sqlarea,

 dba_users

where 

active_session_history.sample_time between sysdate -  1/24  and sysdate

  and active_session_history.sql_id = sqlarea.sql_id

and active_session_history.user_id = dba_users.user_id

 group by active_session_history.sql_id,sqlarea.sql_text, dba_users.username

 order by 4 desc )

where rownum < 10;