test msg- please disregard.

sql --

select * from (

      
select d.username, max(b.last_load_time),SUBSTR (trim(sql_text), 1, 500)
"SQL",

      
a.SQL_ID,

       
sum(CPU_TIME_DELTA),

      
sum(NVL(DISK_READS_DELTA,0)),

      
count(*)

      
from

      
DBA_HIST_SQLSTAT a, dba_hist_snapshot s, gv$sql b, DBA_HIST_ACTIVE_SESS_HISTORY
c, dba_users d

      
where

      
s.snap_id = a.snap_id

      
and a.sql_id=b.sql_id

      
and a.sql_id=c.sql_id

      
and c.user_id=d.user_id

      
and s.begin_interval_time > sysdate -1

              
and sql_text not like '%OracleOEM%'

      
and EXTRACT(HOUR FROM S.END_INTERVAL_TIME) between 1 and 11