select
  inst_id,                                 -- INST_ID NUMBER
  cor.blkfno,                              -- FILE# NUMBER
  cor.blksblk,                             -- BLOCK# NUMBER
  cor.blktot,                              -- BLOCKS NUMBER
  cor.blkscn,                              -- CORRUPTION_CHANGE# NUMBER
  decode(                                  -- CORRUPTION_TYPE VARCHAR2(9)
    cor.blktype, 2, 'ALL ZERO', 3,'FRACTURED', 4,'CHECKSUM', 5,'CORRUPT', 6, 'NOLOGGING', 7, 'LOGICAL', 'UNKNOWN') 
from
  x$kccblkcor cor,
  v$datafile df
where
  cor.blktype != 1 and cor.blkfno = df.file# and cor.blkcrs = df.creation_change# and cor.blkcrt = df.creation_time