DBA_SEGMENTS
Informations sur les espaces alloués pour les segments .
| Nom de la colonne | Description |
| OWNER | Username of the segment owner |
| SEGMENT_NAME | Name, if any, of the segment |
| SEGMENT_TYPE |
Type of segment: TABLE, CLUSTER, INDEX, ROLLBACK, DEFERRED ROLLBACK, TEMPORARY, or CACHE
|
| TABLESPACE_NAME | Name of the tablespace containing the segment |
| HEADER_FILE | ID of the file containing the segment header |
| HEADER_BLOCK | ID of the block containing the segment header |
| BYTES | Size in bytes, of the segment |
| BLOCKS | Size, in Oracle blocks, of the segment |
| EXTENTS | Number of extents allocated to the segment /font> |
| INITIAL_EXTENT | Size in bytes of the initial extent of the segment |
| NEXT_EXTENT | Size in bytes of the next extent to be allocated to the segment |
| MIN_EXTENTS | Minimum number of extents allowed in the segment |
| MAX_EXTENTS | Maximum number of extents allowed in the segment |
| PCT_INCREASE |
Percent by which to increase the size of the next extent to be allocated
|
| FREELISTS | Number of process freelists allocated to this segment |
| FREELIST_GROUPS | Number of freelist groups allocated to this segment |