GV$CONTROLFILE definition in Oracle Database 11.2
GV$CONTROLFILE

select
  inst_id,                                 -- INST_ID NUMBER
  decode(                                  -- STATUS VARCHAR2(7)
    bitand(cfflg,1),0,'',1,'INVALID'),
  cfnam,                                   -- NAME VARCHAR2(513)
  decode(                                  -- IS_RECOVERY_DEST_FILE VARCHAR2(3)
    bitand(cffl2,1),0,'NO','YES'),
  cfbsz,                                   -- BLOCK_SIZE NUMBER
  cffsz                                    -- FILE_SIZE_BLKS NUMBER
from
  x$kcccf

home |  up