ablog

不器用で落着きのない技術者のメモ

Oracle

SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME FROM DBA_EXTENTS
WHERE 80 = FILE_ID AND 112000 BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS -1;