Number of executions in AWR report
Hello!
Can You please explain , the reason of the big difference of values in section
"Top SQL Comparison by Executions" (#Executions) in AWR report and result of query (the same period)
SELECT count(*) ,sql_id, user_id, machine,
(select username from dba_users where user_id = a.user_id) ,
to_char(trunc(a.SAMPLE_TIME, 'mi'), 'dd-mon-yyyy hh24:mi')
FROM dba_hist_active_sess_history a
WHERE
a.SAMPLE_TIME between ...
and sql_id in ( ...)
group by sql_id, user_id, machine, to_char(trunc(a.SAMPLE_TIME, 'mi'), 'dd-mon-yyyy hh24:mi')
order by to_char(trunc(a.SAMPLE_TIME, 'mi'), 'dd-mon-yyyy hh24:mi');