Oracle 获取 * 历史 * 查询/会话/sql_id的详细信息，以生成最近一周的大量重做。

select s.begin_interval_time, s.end_interval_time, 
       ss.sql_id, st.sql_text, 
       ss.executions_delta, ss.rows_processed_delta 
from   dba_hist_sqlstat ss
join   dba_hist_sqltext st
on     ss.sql_id = st.sql_id
join   dba_hist_snapshot s
on     ss.snap_id = s.snap_id
and    ss.instance_number = s.instance_number
order  by s.begin_interval_time, ss.rows_processed_delta desc