Workbook runs by Hour

This chart shows what is the average peak hour for workbook usage.

select run_hour, 'Runs by Hour', round(sum(runs)/ count(run_hour)) hourly_runs
from
(
select run_month,month_day,run_hour,count(*) runs
from
(
select qs_cost cost
, qs_act_cpu_time cpu_time
, qs_act_elap_time elapsed_time
, qs_num_rows rows_fetched
, qs_doc_owner doc_owner
, qs_doc_name workbook
, qs_doc_details worksheet
, qs_created_date run_date
, to_char(qs_created_date,'D') week_day
, to_char(qs_created_date,'DD') month_day
, to_char(qs_created_date,'Day') run_day
, to_char(qs_created_date,'Mon') run_month
, to_char(qs_created_date,'HH24') run_hour
, to_char(qs_created_date,'YYYY') run_year
from eul5_qpp_stats
where qs_created_date between sysdate - 30 and sysdate
) stats
group by run_month,month_day,run_hour
)
group by run_hour