[管理脚本] MyStat

set verify off
column value new_val V
column value format 999,999,999,999
define S="&1"

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