GV$ASM_ALIAS

select
inst_id,                 -- INST_ID NUMBER
name_kfals,              -- NAME VARCHAR2(48)
group_kfals,             -- GROUP_NUMBER NUMBER
number_kfals,            -- FILE_NUMBER NUMBER
incarn_kfals,            -- FILE_INCARNATION NUMBER
entnum_kfals,            -- ALIAS_INDEX NUMBER
entinc_kfals,            -- ALIAS_INCARNATION NUMBER
parent_kfals,            -- PARENT_INDEX NUMBER
refer_kfals,             -- REFERENCE_INDEX NUMBER
decode                   -- ALIAS_DIRECTORY VARCHAR2(1)
  (bitand (entflg_kfals, 12), 4, 'Y', 8, 'Y', 'N'),
decode                   -- SYSTEM_CREATED VARCHAR2(1)
  (bitand (entflg_kfals, 15), 1, 'N', 2, 'Y', 4, 'Y', 8, 'N') 
from
x$kfals 
where
decode (bitand (entflg_kfals, 12), 4, 'Y', 8, 'Y', 'N') = 'Y' OR decode (bitand (entflg_kfals, 16), 16, 'Y', 'N') = 'Y'
home |  up  |  mailbox