How to find segment name from file id and block number in Oracle
In Oracle, if you have a file ID (file number) and block number, and you want to find the corresponding segment name (such as a table or index name), you can use the DBA_EXTENTS data dictionary view. This view maps extents (which consist of continuous blocks) to segments. The below query can be used for …
How to find segment name from file id and block number in Oracle Read More »