Query to Find Out the File and Block IDs : DBA_EXTENTS « System Tables Views « Oracle PL / SQL






Query to Find Out the File and Block IDs

  
SQL>
SQL> SELECT SEGMENT_NAME,
  2     FILE_ID,
  3     BLOCK_ID
  4     FROM DBA_EXTENTS
  5    WHERE OWNER = 'OE'
  6   AND SEGMENT_NAME LIKE 'ORDERS%'
  7  /

no rows selected

SQL>
SQL> --

   
  








Related examples in the same category

1.Query DBA_EXTENTS for Extent number in the segment, Starting block number for the extent, Size of the extent in bytes, Size of the extent, in Oracle blocks
2.Query DBA_EXTENTS for Name of the segment, Type of segment (ex. TABLE, INDEX)
3.Query DBA_EXTENTS for Tablespace name,Owner of the segment