GV$ASM_TEMPLATE

select
inst_id,                 -- INST_ID NUMBER
group_kftmta,            -- GROUP_NUMBER NUMBER
entry_kftmta,            -- ENTRY_NUMBER NUMBER
decode                   -- REDUNDANCY VARCHAR2(6)
  (redundancy_kftmta, 17, 'UNPROT', 18, 'MIRROR', 19, 'HIGH', 35, 'PARITY', 36, 'PARITY', 37, 'PARITY', 38, 'PARITY'),
decode                   -- STRIPE VARCHAR2(6)
  (bitand (flags_kftmta, 1), 1, 'FINE', 'COARSE'),
decode                   -- SYSTEM VARCHAR2(1)
  (bitand (flags_kftmta, 4), 4, 'Y', 'N'),
name_kftmta              -- NAME VARCHAR2(30)
from
x$kftmta
home |  up  |  mailbox