1 2 3 4 5 6 7 8
|
select trunc(status_date,'mi') as time, count(*) as transactionCount, avg(execution_time / 60) as exec_time_min
(status_state >= to_date('23/11/2008 18:00:00', 'dd/mm/yyyy hh24:mi:ss') and status_state <to_date('24/11/2008 02:00:00', 'dd/mm/yyyy hh24:mi:ss')) as status_state
from tx_active
where (creation_date >= sysdate - 1/24) and (status_state >= (creation_date - interval 7 hour))
and status_state = 'SUCCESS'
group by trunc(status_date,'mi')
order by avg(execution_time / 60), trunc(status_date,'mi') desc; |
Partager