Tag: DBA_EXTENTS

  • Efficiently query DBA_EXTENTS for FILE_ID / BLOCK_ID

    Efficiently query DBA_EXTENTS for FILE_ID / BLOCK_ID

    Efficiently query DBA_EXTENTS for FILE_ID / BLOCK_ID Did you ever try to query DBA_EXTENTS on a very large database with LMT tablespaces? I had to, in the past, in order to find which segment a corrupt block belonged to. The information about extent allocation is stored in the datafiles headers, visible though X$KTFBUE, and queries

    Explore →