文章目录
标签(空格分隔): Oracle 脚本
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select *
from (select a.instance_number,
a.snap_id,
b.begin_interval_time + 0 begin_time,
b.end_interval_time + 0 end_time,
round(value - lag(value, 1, '0')
over(order by a.instance_number, a.snap_id)) "db time"
from (select b.snap_id,
instance_number,
sum(value) / 1000000 / 60 value
from dba_hist_sys_time_model b
where b.dbid = (select dbid from v$database)
and upper(b.stat_name) in upper(('db time'))
group by b.snap_id, instance_number) a,
dba_hist_snapshot b
where a.snap_id = b.snap_id
and b.dbid = (select dbid from v$database)
and b.instance_number = a.instance_number)
where to_char(begin_time, 'yyyy-mm-dd') = to_char(sysdate, 'yyyy-mm-dd')
and instance_number = &inst_id
order by begin_time, instance_number;