WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;

spool sys_runtime_req_summary_hour.log



prompt
prompt Creating table sys_runtime_req_summary_hour
prompt ====================================
prompt
whenever sqlerror continue
drop table sys_runtime_req_summary_hour;
whenever sqlerror exit failure rollback


create table sys_runtime_req_summary_hour
(
       id               number,
       day              date            not null,--yyyy/mm/dd
       hour             varchar2(10)    not null,--hh24
       visits           number not null,
       med_dur_screen   number not null,--screen平均访问时间
       med_dur_svc      number not null,--svc平均访问时间
       med_dur_query    number not null,--query平均时间
       max_dur_screen   number not null,
       max_dur_svc      number not null,
       max_dur_query    number not null,
       min_dur_screen   number not null,
       min_dur_svc      number not null,
       min_dur_query    number not null,
       avg_dur_screen   number not null,
       avg_dur_svc      number not null,
       avg_dur_query    number not null
);
create index req_summary_hour_idx1 on sys_runtime_req_summary_hour(day);
alter table sys_runtime_req_summary_hour add primary key(id);



spool off
exit