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