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  |  mailbox