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 Views « Oracle PL / SQL
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
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>