select id, name from cond order by name;
prompt Which Database ID
accept DBID
prompt Enter Start Date (mm/dd/yy hh24:mi)
accept BeginDate
prompt Enter End Date (mm/dd/yy hh24:mi)
accept EndDate
Rem
Rem
variable secs number
begin
:secs := (to_date('&EndDate','mm/dd/yy hh24:mi') - to_date('&BeginDate','mm/dd/yy hh24:mi')) * 24*60*60;
end;
/
set pagesize 999
set linesize 132
select trunc(datehour) day,
sum(timesecs) total_wait_time,
sum(execs) transactions,
round(sum(execs)/:secs,2) trans_per_sec,
sum(row_count) row_count
from con_stats_sum_&DBID
where datehour between to_date('&BeginDate','mm/dd/yy hh24:mi') and to_date('&EndDate','mm/dd/yy hh24:mi')
group by trunc(datehour)
order by 1
/
