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