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+32), 8, '', 32, '', 40, '', 'UNKNOWN'))))),
decode                   -- TYPE VARCHAR2(7)
  (bitand (fnflg, 8), 0, 'ONLINE', 'STANDBY'),
fnnam,                   -- MEMBER VARCHAR2(513)
decode                   -- IS_RECOVERY_DEST_FILE VARCHAR2(3)
  (bitand (fnflg, 32), 0, 'NO', 'YES') 
from
x$kccfn 
where
fnnam is not null and fntyp=3
home |  up  |  mailbox