The application team claims there was a statement that took about 30s to execute at about a certain time.
I tried to find out what queries had been executed in during this time with the following statement:
select a.sql_id, sample_time from dba_hist_active_sess_history a, dba_hist_sqltext b where sample_time between to_date('20170330:13:15','yyyymmdd:hh24:mi') and to_date('20170330:13:25','yyyymmdd:hh24:mi') and b.sql_id=a.sql_id order by 2;
However, only statements concerning rman, or the cloud control agent show up and no statement that seems to be from the application.
Could it be that some queries executed do not show up in the
dba_hist_active_sess_history table and where else could I look for it?