--SELECT dhss.sql_id,dhss.module,dhss.action,begin_interval_time,dbms_lob.substr(sql_text,4000,1) FROM dba_hist_sqlstat dhss, dba_hist_snapshot dhs, dba_hist_sqltext dhst WHERE upper(dhst.sql_text) LIKE '%LIVE_SUMMARY%' AND dhss.snap_id=dhs.snap_id AND dhss.instance_Number=dhs.instance_number --AND begin_interval_time BETWEEN to_date('2022_03_05 04','YYYY_MM_DD HH24') AND to_date('2022_03_05 05','YYYY_MM_DD HH24') AND dhss.sql_id = dhst.sql_id and rownum<2 /