sql developer daily ash statistics chart query

From: LS Cheng <exriscer@xxxxxxxxx>
To: Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 9 Nov 2011 01:01:43 +0100

Hi
In SQL Developer there are few AWR/ASH report available, one of them is
daily ash statistics chart and made up by following query

select to_char(trunc((sample_time),'HH'),'HH24:MI'), state, count(*)/360
from
  (select   sample_time,   sample_id
  ,  CASE  WHEN session_state = 'ON CPU' THEN 'CPU'
           WHEN session_state = 'WAITING' AND wait_class IN ('User I/O')
THEN 'IO'
           WHEN session_state = 'WAITING' AND wait_class IN ('Cluster')
THEN 'CLUSTER'
           ELSE 'WAIT' END state
    from DBA_HIST_ACTIVE_SESS_HISTORY
    where   session_type IN ( 'FOREGROUND')
    and sample_time  between trunc(sysdate,'HH') - 25/24 and
trunc(sysdate,'HH') - 1/24  )
group by trunc((sample_time),'HH'), state order by trunc((sample_time),'HH')

Does anyone know why we divide count(*) by 360?

Thanks

--
LSC


--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Re: sql developer daily ash statistics chart query
  - From: Martin Berger

sql developer daily ash statistics chart query

Other related posts: