Purpose
The DBA_SEGMENTS view displays the storage allocated for all segments in the database.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
References
USER_SEGMENTS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the segment. |
| SEGMENT_NAME | VARCHAR2(128) | NO | The name of the segment if any. |
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the partition. For non-partitioned objects, the value of this column is NULL. |
| SEGMENT_TYPE | VARCHAR2(18) | NO | The type of the segment. |
| SEGMENT_SUBTYPE | VARCHAR2(10) | NO | At present, this column is not supported and its value is NULL by default. |
| TABLESPACE_NAME | VARCHAR2(30) | NO | At present, this column is not supported and its value is NULL by default. |
| HEADER_FILE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| HEADER_BLOCK | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| BYTES | NUMBER(38) | NO | The size of the segment in bytes. |
| BLOCKS | NUMBER(38) | NO | The size of the segment block. |
| EXTENTS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| INITIAL_EXTENT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| NEXT_EXTENT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MIN_EXTENTS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MAX_EXTENTS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MAX_SIZE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| RETENTION | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| MINRETENTION | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| PCT_INCREASE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| FREELISTS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| FREELIST_GROUPS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| RELATIVE_FNO | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| BUFFER_POOL | VARCHAR2(7) | NO | The buffer pool for segment blocks. |
| FLASH_CACHE | VARCHAR2(7) | NO | The database smart flash cache hint for segment blocks. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | The cell flash cache hint for segment blocks. |