|
Listing 5: Creating the Statistics Tables
SQL> create table run_stats ( runid varchar2(15), name varchar2(80), value int );
Table created.
SQL> 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 'LATCH.' || name, gets
7 from v$latch;
View created.
SQL> create table t ( x int );
Table created.
|