PRoblem that I see now is that change “v$active…” and “DBA_ACTIVE…” result with the same data:
Timestamp: 10:17:06.425
Select decode(session_state, ‘WAITING’, Event, ‘ON CPU’, ‘Waiting on CPU’) event,
sum(decode(session_state, ‘WAITING’, time_waited, ‘ON CPU’, wait_time)) wait_time
from v$active_Session_history
where 1=1
and sample_time >= :MinSampTime
and sample_time <= :MaxSampTime
group by decode(session_state, ‘WAITING’, Event, ‘ON CPU’, ‘Waiting on CPU’)
order by 2 desc
:MinSampTime(DATE)=08.08.2016 03:00:18
:MaxSampTime(DATE)=08.08.2016 05:45:00
Session: Q383211@MOBENB0
Timestamp: 10:17:36.072
Select decode(session_state, ‘WAITING’, Event, ‘ON CPU’, ‘Waiting on CPU’) event,
sum(decode(session_state, ‘WAITING’, time_waited, ‘ON CPU’, wait_time)) wait_time
from v$active_Session_history
where 1=1
and sample_time >= :MinSampTime
and sample_time <= :MaxSampTime
group by decode(session_state, ‘WAITING’, Event, ‘ON CPU’, ‘Waiting on CPU’)
order by 2 desc
:MinSampTime(DATE)=08.08.2016 03:00:18
:MaxSampTime(DATE)=08.08.2016 05:45:00
So there is a bug definitely.