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 : dba_extents « System Tables Data Dictionary « Oracle PL/SQL Tutorial






SQL> select
  6        Extent_ID,         /*Extent number in the segment*/
  7        Block_ID,          /*Starting block number for the extent*/
  8        Bytes,             /*Size of the extent, in bytes*/
  9        Blocks             /*Size of the extent, in Oracle blocks*/
 10   from DBA_EXTENTS
 11  where Segment_Name = 'segment_name'
 12  order by Extent_ID;
SQL>
SQL>








30.30.dba_extents
30.30.1.Join dba_extents and dba_rollback_segs
30.30.2.Query dba_extents for segment name
30.30.3.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
30.30.4.Query DBA_EXTENTS for Name of the segment, Type of segment (ex. TABLE, INDEX)
30.30.5.Query DBA_EXTENTS for Tablespace name,Owner of the segment
30.30.6.Log dba_extents