GV$LOGFILE

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