16 lines
425 B
SQL
16 lines
425 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#,
|
|
n.statistic# * 8 offset,
|
|
n.name,
|
|
s.value,
|
|
to_char(s.value, 'XXXXXXXXXXXXXXXX') value_hex
|
|
from v$mystat s, v$statname n
|
|
where s.statistic#=n.statistic#
|
|
and lower(n.name) like lower('%&1%')
|
|
and rownum <= &2
|
|
/
|
|
|