Hello,
Using Oracle 11g XE. According to the Oracle documentation, the NEXT_EXTENT column of the dba_segments table is defined as
Size in bytes of the next extent to be allocated to the segment
However, the number of bytes in my table is inconsistent with the documentation's definition. You can see below that the bytes column shows twice the number of the initial_extents column, not the size of the initial_extent column plus the size of the next_extent column as expected. Does anyone know why?
SQL> select bytes, blocks, extents, initial_extent, next_extent from dba_segments where segment_name = 'ZIPCODE';
BYTES BLOCKS EXTENTS INITIAL_EXTENT NEXT_EXTENT
---------- ---------- ---------- -------------- -----------
131072 16 2 65536 1048576
SQL>