GV$COPY_CORRUPTION
select inst_id, -- INST_ID NUMBER ccrid, -- RECID NUMBER ccstm, -- STAMP NUMBER ccdcp, -- COPY_RECID NUMBER ccdcs, -- COPY_STAMP NUMBER ccdfp, -- FILE# NUMBER ccblk, -- BLOCK# NUMBER cccnt, -- BLOCKS NUMBER to_number (ccscn), -- CORRUPTION_CHANGE# NUMBER decode -- MARKED_CORRUPT VARCHAR2(3) (bitand (ccflg, 1), 1, 'YES', 'NO'), decode -- CORRUPTION_TYPE VARCHAR2(9) (bitand (ccflg, 30), 2, 'ALL ZERO', 4, 'FRACTURED', 8, 'CHECKSUM', 16, 'CORRUPT', 'LOGICAL') from x$kcccc

home |  up  |  mailbox