cpu.sql
code:SQL
set lines 120
set pages 20000
col IDLE% for 990.9
col USER% for 990.9
col SYS% for 990.9
col NICE% for 990.9
col WIO% for 990.9
col LOAD for 990.9
select
to_char(SDATE,'yyyy/mm/dd hh24:mi:ss') SDATE
,(IDLE_TIME - (lag(IDLE_TIME,1) over (order by SDATE)))/
((IDLE_TIME - (lag(IDLE_TIME,1) over (order by SDATE)))
+(BUSY_TIME - (lag(BUSY_TIME,1) over (order by SDATE))))*100 "IDLE%"
,(USER_TIME - (lag(USER_TIME,1) over (order by SDATE)))/
((IDLE_TIME - (lag(IDLE_TIME,1) over (order by SDATE)))
+(BUSY_TIME - (lag(BUSY_TIME,1) over (order by SDATE))))*100 "USER%"
,(SYS_TIME - (lag(SYS_TIME ,1) over (order by SDATE)))/
((IDLE_TIME - (lag(IDLE_TIME,1) over (order by SDATE)))
+(BUSY_TIME - (lag(BUSY_TIME,1) over (order by SDATE))))*100 "SYS%"
,(NICE_TIME - (lag(NICE_TIME ,1) over (order by SDATE)))/
((IDLE_TIME - (lag(IDLE_TIME,1) over (order by SDATE)))
+(BUSY_TIME - (lag(BUSY_TIME,1) over (order by SDATE))))*100 "NICE%"
,(IOWAIT_TIME - (lag(IOWAIT_TIME ,1) over (order by SDATE)))/
((IDLE_TIME - (lag(IDLE_TIME,1) over (order by SDATE)))
+(BUSY_TIME - (lag(BUSY_TIME,1) over (order by SDATE))))*100 "WIO%"
,LOAD
from user$osstat
;
set lines 80
set pages 14