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