-- Purpose: Just queries v$mystat for stat_name col name for a70 col value for 99999999999999 select name, value from v$mystat s, v$statname n where n.statistic# = s.statistic# and name like nvl('%&name%',name) order by 1 / col name clear col value clear