Grouper Users - Open Discussion List

[Andrew Morgan <>]

On Tue, 14 Feb 2017, Michael R Gettes wrote:

> And, in case anyone is interested, here is what I use to do the calculation:
>
> select
>  to_char ( sum (TOTAL_COUNT) / (sum (MILLIS)/1000), '9999.99') as 
> AVERAGE_PER_SECOND,
>  to_char ( sum (TOTAL_COUNT), '9999999') as TOTAL_CHANGES,
>  to_char ( count ( MILLIS ), '999999') as TOTAL_JOBS,
>  to_char ( sum (MILLIS) / 1000, '999999.99' ) as TOTAL_SECONDS
>  from grouper_loader_log
>  where ( job_name like '%CHANGE_LOG_ch%' ) and ENDED_TIME is not null
>    and (STARTED_TIME >= trunc(sysdate-1) -- today and yesterday
>  )
>  and TOTAL_COUNT > 0 ;
>
> I am curious as to the performance seen by others.  We are on Oracle - 
> but I am interested in other DB product numbers as well.

Here is our output:

AVERAGE_ TOTAL_CH TOTAL_J TOTAL_SECO
-------- -------- ------- ----------
   14.25     7135     120     500.76


We are running on Oracle as well.

        Andy