Note
This view is available starting with V2.2.30.
Purpose
This view displays the physical storage allocation of all segments in the current tenant.
Applicability
This view only applies to OceanBase Database in Oracle-compatible mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner's name. |
| SEGMENT_NAME | VARCHAR2(128) | NO | The segment name, if any. |
| PARTITION_NAME | VARCHAR2(128) | NO | The partition name. If the object is not partitioned, it is NULL. |
| SEGMENT_TYPE | VARCHAR2(18) | NO | The type of the segment. |
| SEGMENT_SUBTYPE | VARCHAR2(10) | NO | This column is not supported and defaults to NULL. |
| TABLESPACE_NAME | VARCHAR2(30) | NO | This column is not supported and defaults to NULL. |
| HEADER_FILE | NUMBER | NO | This column is not supported and defaults to NULL. |
| HEADER_BLOCK | NUMBER | NO | This column is not supported and defaults to NULL. |
| BYTES | NUMBER(38) | NO | The size of the segment, in bytes. |
| BLOCKS | NUMBER(38) | NO | The number of blocks in the segment. |
| EXTENTS | NUMBER | NO | This column is not supported and defaults to NULL. |
| INITIAL_EXTENT | NUMBER | NO | This column is not supported and defaults to NULL. |
| NEXT_EXTENT | NUMBER | NO | This column is not supported and defaults to NULL. |
| MIN_EXTENTS | NUMBER | NO | This column is not supported and defaults to NULL. |
| MAX_EXTENTS | NUMBER | NO | This column is not supported and defaults to NULL. |
| MAX_SIZE | NUMBER | NO | This column is not supported and defaults to NULL. |
| RETENTION | VARCHAR2(7) | NO | This column is not supported and defaults to NULL. |
| MINRETENTION | NUMBER | NO | This column is not supported and defaults to NULL. |
| PCT_INCREASE | NUMBER | NO | This column is not supported and defaults to NULL. |
| FREELISTS | NUMBER | NO | This column is not supported and defaults to NULL. |
| FREELIST_GROUPS | NUMBER | NO | This column is not supported and defaults to NULL. |
| RELATIVE_FNO | NUMBER | NO | This column is not supported and defaults to NULL. |
| BUFFER_POOL | VARCHAR2(7) | NO | The buffer pool used for the segment blocks. |
| FLASH_CACHE | VARCHAR2(7) | NO | The intelligent flash cache hint for the segment blocks. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | The cell flash cache hint for the segment blocks. |
| CELLMEMORY | varchar(24) | NO | This column is not supported and defaults to NULL. |
| INMEMORY | varchar(8) | NO | This column is not supported and defaults to NULL. |
| INMEMORY_PRIORITY | varchar(8) | NO | This column is not supported and defaults to NULL. |
| INMEMORY_DISTRIBUTE | varchar(15) | NO | This column is not supported and defaults to NULL. |
| INMEMORY_DUPLICATE | varchar(13) | NO | This column is not supported and defaults to NULL. |
| INMEMORY_COMPRESSION | varchar(17) | NO | This column is not supported and defaults to NULL. |
Sample query
Query the physical storage allocation of the T_SUBPART table in the current tenant.
obclient [SYS]> SELECT OWNER, SEGMENT_NAME, PARTITION_NAME, SEGMENT_TYPE, BYTES, BLOCKS FROM SYS.DBA_SEGMENTS WHERE SEGMENT_NAME='T_SUBPART';
The query result is as follows:
+-------+--------------+----------------+--------------------+---------+--------+
| OWNER | SEGMENT_NAME | PARTITION_NAME | SEGMENT_TYPE | BYTES | BLOCKS |
+-------+--------------+----------------+--------------------+---------+--------+
| SYS | T_SUBPART | P1SP0 | TABLE SUBPARTITION | 2097152 | 16384 |
| SYS | T_SUBPART | P1SP1 | TABLE SUBPARTITION | 2097152 | 16384 |
| SYS | T_SUBPART | P1SP2 | TABLE SUBPARTITION | 2097152 | 16384 |
| SYS | T_SUBPART | P1SP3 | TABLE SUBPARTITION | 2097152 | 16384 |
| SYS | T_SUBPART | P2SP0 | TABLE SUBPARTITION | 2097152 | 16384 |
| SYS | T_SUBPART | P2SP1 | TABLE SUBPARTITION | 2097152 | 16384 |
| SYS | T_SUBPART | P2SP2 | TABLE SUBPARTITION | 2097152 | 16384 |
| SYS | T_SUBPART | P2SP3 | TABLE SUBPARTITION | 2097152 | 16384 |
| SYS | T_SUBPART | P3SP0 | TABLE SUBPARTITION | 2097152 | 16384 |
| SYS | T_SUBPART | P3SP1 | TABLE SUBPARTITION | 2097152 | 16384 |
| SYS | T_SUBPART | P3SP2 | TABLE SUBPARTITION | 2097152 | 16384 |
| SYS | T_SUBPART | P3SP3 | TABLE SUBPARTITION | 2097152 | 16384 |
+-------+--------------+----------------+--------------------+---------+--------+
12 rows in set
References
To view the physical storage allocation of segments owned by the current user, query USER_SEGMENTS.