Many times, you might need to determine the Segment name given the file id and block number. The below query can be used for that SELECT segment_name, segment_typeFROM dba_extentsWHERE file_id = AND BETWEEN block_id and block_id + blocks - 1; Example SELECT segment_name, segment_type FROM dba_extents WHERE file_id = 101 AND 8758758 BETWEEN […]

The post find segment name from block in Oracle appeared first on Techgoeasy.