DBA_HIST_TIME_MODEL 11.2.0.4

Hello everyone

We stumbled upon a  script to identify the busiest time of the database . The script is called dbtime.sql  and we got that from Kerry Osborne Oracle Blog

http://kerryosborne.oracle-guy.com/2009/05/awr-dbtime-script/

Here is the script

select * from (

select begin_snap, end_snap, timestamp begin_timestamp, inst, a/1000000/60 DBtime from

(

select

e.snap_id end_snap,

lag(e.snap_id) over (order by e.instance_number,e.snap_id) begin_snap,

lag(s.end_interval_time) over (order by e.instance_number,e.snap_id) timestamp,

s.instance_number inst,

e.value,

nvl(value-lag(value) over (order by e.instance_number,e.snap_id),0) a