mystat.sql

Expert Oracle Database Architecture 9i and 10g 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