Runstats

sys@DENVER> create or replace view stats
  2  as select 'STAT...'||a.name name, b.value
  3       from v$statname a, v$mystat b
  4     where a.statistic#=b.statistic#
  5     union all
  6     select 'LATACH.'||name, gets
  7       from v$latch
  8     union all
  9     select 'STAT...Elapsed Time', hsecs from v$timer;

View created.