CASS

--- chkstats.sql get a snap shot of sys & sess stats from when chkstatc was run 

col STAT_NAME format a40
col STAT_VALUE format 999,999,999,999 

select c.STAT_NAME, s.SESS_VALUE - c.SESS_VALUE SESS_VALUE, s.SYS_VALUE- c.SYS_VALUE SYS_VALUE
from chkstat_tmptab c,
  (SELECT  name.name stat_name, sstat.value SYS_VALUE, mstat.value SESS_VALUE
   FROM  v$sysstat sstat, v$statname name, v$mystat mstat
   WHERE sstat.statistic# = name.statistic#
   and   mstat.statistic# = name.statistic#
   and   name.name in
   ('recursive calls','db block gets','consistent gets','physical reads','redo size','bytes sent via SQL*Net to client'
   ,'bytes received via SQL*Net from client','SQL*Net roundtrips to/from client','sorts (memory)','sorts (disk)')) s
where c.STAT_NAME = s.STAT_NAME
order by  c.STAT_NAME;