Efficiently query DBA_EXTENTS for FILE_ID / BLOCK_ID

(Franck Pachot) 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.

Register to Read