@nls

select T.date_load, T.inst_id, trunc(T.load_avg), trunc(T.cpu_perc_usage) from ASTSYSADMIN.t_current_load_os T
where T.inst_id = &1
and T.date_load between to_date(to_char(sysdate,'ddmmyyyy')||' &2'||':00','ddmmyyyy hh24:mi:ss') and to_date(to_char(sysdate,'ddmmyyyy')||' &2'||':00','ddmmyyyy hh24:mi:ss') + 5/24/60;

select T.*,sum(count_proc) over(partition by date_load) total from ASTSYSADMIN.T_CURRENT_LOAD T
where T.inst_id = &1
and T.date_load between to_date(to_char(sysdate,'ddmmyyyy')||' &2'||':00','ddmmyyyy hh24:mi:ss') and to_date(to_char(sysdate,'ddmmyyyy')||' &2'||':00','ddmmyyyy hh24:mi:ss') + 5/24/60
and T.username is not null
order by T.count_proc desc;

select T.*,sum(count_proc) over(partition by date_load) total from ASTSYSADMIN.T_CURRENT_LOAD T
where T.inst_id = &1
and T.date_load between to_date(to_char(sysdate,'ddmmyyyy')||' &2'||':00','ddmmyyyy hh24:mi:ss') and to_date(to_char(sysdate,'ddmmyyyy')||' &2'||':00','ddmmyyyy hh24:mi:ss') + 5/24/60
and T.service_name is not null
order by T.count_proc desc;

select T.*,sum(count_proc) over(partition by date_load) total from ASTSYSADMIN.T_CURRENT_LOAD T
where T.inst_id = &1
and T.date_load between to_date(to_char(sysdate,'ddmmyyyy')||' &2'||':00','ddmmyyyy hh24:mi:ss') and to_date(to_char(sysdate,'ddmmyyyy')||' &2'||':00','ddmmyyyy hh24:mi:ss') + 5/24/60
and T.profile is not null
order by T.count_proc desc;


