Query not showing in dba_hist_active_sess_history
2
votes
1
answer
3621
views
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?
Asked by jera
(165 rep)
Apr 4, 2017, 10:18 AM
Last activity: Apr 4, 2017, 12:12 PM
Last activity: Apr 4, 2017, 12:12 PM