22 lines
565 B
SQL
22 lines
565 B
SQL
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
|
|
|
select
|
|
n.statistic# stat#,
|
|
trim(to_char(s.statistic#, 'XXXX')) hex#,
|
|
n.statistic# * 8 offset,
|
|
n.name,
|
|
s.value
|
|
from v$mystat s, v$statname n
|
|
where s.statistic#=n.statistic#
|
|
and (
|
|
lower(n.name) like lower('%&1%')
|
|
or lower(to_char(s.statistic#)) like lower('&1')
|
|
or lower(trim(to_char(s.statistic#, 'XXXX'))) like lower('&1')
|
|
or to_char(n.statistic# * 8) like '%&1%'
|
|
)
|
|
/
|
|
|
|
|
|
|