oracle 的mystat

mystat.sql

---------------------------------------------------------------

set echo off
set verify off
column value new_val V
define S='&1'


set autotrace off
select a.name, b.value from v$statname a, v$mystat b
where a.STATISTIC# = b.STATISTIC# and lower(a.name) like '%' || lower('%S')|| '%'
/
set echo on

-------------------------------------------------------------------

mystat2.sql

-------------------------------------------------------------------

set echo off

set verify off

 select a.name, b.value V, to_char(b.value-&V,'999,999,999,999') diff

where a.statistic# = b.statistic#

and lower(a.name) like '%' || lower('&S') || '%'

/

set echo on

-------------------------------------------------------------------