Finding all sql id, sql text, number of executions, execution time between two AWR snap ids in oracle The AWR report provides the SQL information for top 10-20 SQL statements. Is it possible to get information on SQL statements that do not make it to the top list?  How do we find all sql id, sql text, number of executions, execution time between two AWR snap ids in oracle?
You can select from the below views.


Historical SQL statistics: DBA_HIST_SQLSTAT
All SQL text: DBA_HIST_SQLTEXT
Map snap_id to actual time: DBA_HIST_SNAPSHOT