GV$LOGFILE

select
inst_id,                 -- INST_ID NUMBER
fnfno,                   -- GROUP# NUMBER
decode                   -- STATUS VARCHAR2(7)
  (fnflg, 0, '', decode (bitand (fnflg, 1), 1, 'INVALID', decode (bitand (fnflg, 2), 2, 'STALE', decode (bitand (fnflg, 4), 4, 'DELETED', decode (bitand (fnflg, 8), 8, '', 'UNKNOWN'))))),
decode                   -- TYPE VARCHAR2(7)
  (bitand (fnflg, 8), 0, 'ONLINE', 'STANDBY'),
fnnam                    -- MEMBER VARCHAR2(513)
from
x$kccfn 
where
fnnam is not null and fntyp=3
home |  up  |  mailbox