SELECT when, sql, SUM(sx) executions, sum (sd) rows_processed FROM ( SELECT to_char(begin_interval_time,’YYYY_MM_DD HH24′) when, dbms_lob.substr(sql_text,4000,1) sql, dhss.instance_number inst_id, dhss.sql_id, sum(executions_delta) exec_delta, sum(rows_processed_delta) rows_proc_delta FROM dba_hist_sqlstat dhss, dba_hist_snapshot dhs, dba_hist_sqltext dhst…