SQL Code For CPU Performance Extraction/Reporting column usr format 999.99 column sys format 999.99 column util format 999.99 column idle format 999.99 compute avg of usr on day compute avg of sys on day compute avg of util on day compute avg of idle on day break on day skip 1 select host, to_char(dtg, 'yyyy-mm-dd') as day, to_char(dtg, 'hh24') as hour, round(avg(usr),2) as usr, round(avg(system),2) as sys, round(avg(utilization),2) as util, round(avg(idle),2) as idle from smart.cpus where host = 'pm01rg' group by host, to_char(dtg, 'yyyy-mm-dd'), to_char(dtg, 'hh24') HOST DAY HO USR SYS UTIL IDLE ------------ ---------- -- ------- ---------- ---------- ------- pm01rg 2001-03-27 18 1.00 1.09 2.09 97.91 pm01rg 19 1.00 1 2 98.00 pm01rg 20 1.00 1 2 98.00 pm01rg 21 1.00 1 2 98.00 pm01rg 22 1.00 1 2 98.00 pm01rg 23 1.00 1 2 98.00 ********** ------- ---------- ---------- ------- avg 1.00 1.015 2.015 97.99 pm01rg 2001-03-28 00 1.00 1.08 2.08 97.92 pm01rg 01 1.00 1 2 98.00 pm01rg 02 1.00 1 2 98.00 pm01rg 03 1.00 1 2 98.00 pm01rg 04 1.00 1 2 98.00 pm01rg 05 1.00 1 2 98.00 pm01rg 06 1.00 1 2 98.00 pm01rg 07 1.00 1 2 98.00 pm01rg 08 1.00 1 2 98.00 pm01rg 09 1.00 1 2 98.00 pm01rg 10 1.00 1 2 98.00 pm01rg 11 1.00 1 2 98.00 pm01rg 12 1.00 1.08 2.08 97.92 pm01rg 13 1.00 1 2 98.00 pm01rg 14 1.00 1 2 98.00 pm01rg 15 1.50 1.75 3.25 96.75 pm01rg 16 1.00 1 2 98.00 pm01rg 17 1.00 1 2 98.00 pm01rg 18 1.00 1 2 98.00 pm01rg 19 1.00 1 2 98.00 pm01rg 20 1.00 1 2 98.00 pm01rg 21 1.00 1 2 98.00 pm01rg 22 1.00 1 2 98.00 pm01rg 23 1.00 1 2 98.00 ********** ------- ---------- ---------- ------- avg 1.02 1.03791667 2.05875 97.94 pm01rg 2001-03-29 00 1.00 1 2 98.00 pm01rg 01 1.00 1 2 98.00 pm01rg 02 .75 1.08 1.83 98.17 pm01rg 03 2.17 2 4.17 95.33 pm01rg 04 .08 .83 .92 98.92 pm01rg 05 .00 .42 .42 99.00 pm01rg 06 .00 .42 .42 99.00 pm01rg 07 .00 .58 .58 99.00 pm01rg 08 .00 .33 .33 99.00 pm01rg 09 .08 .75 .83 98.92 pm01rg 10 .00 .33 .33 99.00 pm01rg 11 .00 .42 .42 99.00 pm01rg 12 .00 .42 .42 99.00 pm01rg 13 .00 .33 .33 99.00 pm01rg 14 .00 .17 .17 99.00 pm01rg 15 .00 .42 .42 99.00 pm01rg 16 .08 .67 .75 99.00 pm01rg 17 .08 1 1.08 98.83 pm01rg 18 .67 .92 1.58 98.25 pm01rg 19 .42 .67 1.08 98.83 pm01rg 20 .00 .33 .33 99.17 pm01rg 21 .00 .58 .58 99.25 pm01rg 22 .00 .42 .42 99.33 pm01rg 23 .00 .5 .5 99.17 ********** ------- ---------- ---------- ------- avg .26 .649583333 .912916667 98.72 pm01rg 2001-03-30 00 .00 .25 .25 99.25 pm01rg 01 .00 .58 .58 99.17 pm01rg 02 .00 .58 .58 99.17 pm01rg 03 .00 .25 .25 99.33 pm01rg 04 .00 .67 .67 99.17 pm01rg 05 .00 .67 .67 99.25 pm01rg 06 .00 .58 .58 99.00 pm01rg 07 .00 .33 .33 99.50 pm01rg 08 .00 .5 .5 99.25 pm01rg 09 .00 .5 .5 99.25 pm01rg 10 .00 .67 .67 99.08 pm01rg 11 .00 .42 .42 99.42 pm01rg 12 .00 .5 .5 99.17 pm01rg 13 .00 .5 .5 99.33 pm01rg 14 .00 .75 .75 99.25 pm01rg 15 .00 .33 .33 99.25 pm01rg 16 .50 .75 1.25 98.50 pm01rg 17 .25 .92 1.17 98.67 pm01rg 18 .00 .33 .33 99.42 pm01rg 19 .00 .42 .42 99.25 pm01rg 20 .00 .67 .67 99.25 pm01rg 21 .00 .25 .25 99.42 pm01rg 22 .00 .5 .5 99.42 pm01rg 23 .00 .67 .67 99.17 ********** ------- ---------- ---------- ------- avg .03 .524583333 .555833333 99.21 pm01rg 2001-03-31 00 .00 .42 .42 99.17 pm01rg 01 .00 .42 .42 99.17 pm01rg 02 .00 .67 .67 99.08 pm01rg 03 .00 .58 .58 99.17 pm01rg 04 .00 .67 .67 99.08 pm01rg 05 .00 .67 .67 99.08 pm01rg 06 .00 .33 .33 99.25 pm01rg 07 .00 .58 .58 99.25 pm01rg 08 .00 .58 .58 99.17 pm01rg 09 .00 .42 .42 99.25 pm01rg 10 .00 .33 .33 99.25 pm01rg 11 .00 .58 .58 99.33 pm01rg 12 .00 .42 .42 99.17 pm01rg 13 .00 .58 .58 99.17 pm01rg 14 .00 .5 .5 99.42 pm01rg 15 .00 .67 .67 99.17 pm01rg 16 .00 .33 .33 99.25 pm01rg 17 .00 .75 .75 99.25 pm01rg 18 .00 .67 .67 99.33 pm01rg 19 .00 .75 .75 99.08 pm01rg 20 .00 .67 .67 99.17 pm01rg 21 .00 .75 .75 99.25 pm01rg 22 .00 .58 .58 99.08 ********** ------- ---------- ---------- ------- avg .00 .56173913 .56173913 99.20 101 rows selected.