Re: sql developer daily ash statistics chart query

From: <Laimutis.Nedzinskas_at_seb.lt>
Date: Wed, 9 Nov 2011 08:20:52 +0200
Message-ID: <OFFC17A0C1.9BEB53EC-ONC2257943.0022B3A3-C2257943.0022DEAB_at_seb.lt>



AWR samples (by default, which you can change, if you wanna to, etc, etc, etc) at 10 seconds.

Hence this is :

count(*) * 10/3600 - hours spent waiting for

brgds, Laimis N


Please consider the environment before printing this e-mail

                                                                                                                                                   
  From:       Martin Berger <martin.a.berger_at_gmail.com>                                                                                            
                                                                                                                                                   
  To:         exriscer_at_gmail.com                                                                                                                   
                                                                                                                                                   
  Cc:         Oracle Mailinglist <oracle-l_at_freelists.org>                                                                                          
                                                                                                                                                   
  Date:       2011.11.09 08:08                                                                                                                     
                                                                                                                                                   
  Subject:    Re: sql developer daily ash statistics chart query                                                                                   
                                                                                                                                                   





I'd say it is " 1/10 of an hour"
=> 360 sec -> 6 min

I've not checked the Report right now - is it dividing an hour into 10 parts?

that's my guess,
 Martin

On Wed, Nov 9, 2011 at 01:01, LS Cheng <exriscer_at_gmail.com> wrote:
> 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

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

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





--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 09 2011 - 00:20:52 CST

Original text of this message