Sqlstats.sql

-- (c) Kyle Hailey 2007

select
      to_char(sample_time,'DD-MON-YY HH24:MI'),
      executions -
      lag( executions, 1 ) over ( order by sample_time) executions ,
      elapsed_time -
      lag( elapsed_time, 1 ) over ( order by sample_time) elapsed_time ,
      rows_processed -
      lag( rows_processed, 1 ) over ( order by sample_time) rows_processed
from sash_sqlstats
where  hash_value=&hash_value
order by sample_time;