Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
This view displays the names of subpartitions, the names of tables and partitions to which they belong, their storage attributes, and statistics generated by the DBMS_STATS package.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_OWNER | varchar(128) | NO | The owner of the table. |
| TABLE_NAME | varchar(128) | NO | The name of the table. |
| PARTITION_NAME | varchar(128) | NO | The name of the partition. |
| SUBPARTITION_NAME | varchar(128) | NO | The name of the subpartition. |
| HIGH_VALUE | mediumtext | NO | The expression that defines the subpartition. |
| HIGH_VALUE_LENGTH | bigint(20) | NO | The length of the expression that defines the subpartition. |
| PARTITION_POSITION | bigint(20) | NO | The position of the partition. |
| SUBPARTITION_POSITION | bigint(20) | NO | The position of the subpartition in the partition. |
| TABLESPACE_NAME | varchar(30) | NO | The name of the tablespace that contains the subpartition. |
| PCT_FREE | bigint(0) | NO | Not supported. The default value is NULL. |
| PCT_USED | bigint(0) | NO | Not supported. The default value is NULL. |
| INI_TRANS | bigint(0) | NO | Not supported. The default value is NULL. |
| MAX_TRANS | bigint(0) | NO | Not supported. The default value is NULL. |
| INITIAL_EXTENT | bigint(0) | NO | Not supported. The default value is NULL. |
| NEXT_EXTENT | bigint(0) | NO | Not supported. The default value is NULL. |
| MIN_EXTENT | bigint(0) | NO | Not supported. The default value is NULL. |
| MAX_EXTENT | bigint(0) | NO | Not supported. The default value is NULL. |
| MAX_SIZE | bigint(0) | NO | Not supported. The default value is NULL. |
| PCT_INCREASE | bigint(0) | NO | Not supported. The default value is NULL. |
| FREELISTS | bigint(0) | NO | Not supported. The default value is NULL. |
| FREELIST_GROUPS | bigint(0) | NO | Not supported. The default value is NULL. |
| LOGGING | varchar(3) | NO | Not supported. The default value is NULL. |
| COMPRESSION | varchar(8) | NO | Whether the subpartition is compressed. |
| COMPRESS_FOR | varchar(30) | NO | The compression method. |
| NUM_ROWS | bigint(0) | NO | Not supported. The default value is NULL. |
| BLOCKS | bigint(0) | NO | Not supported. The default value is NULL. |
| EMPTY_BLOCKS | bigint(0) | NO | Not supported. The default value is NULL. |
| AVG_SPACE | bigint(0) | NO | Not supported. The default value is NULL. |
| CHAIN_CNT | bigint(0) | NO | Not supported. The default value is NULL. |
| AVG_ROW_LEN | bigint(0) | NO | Not supported. The default value is NULL. |
| SAMPLE_SIZE | bigint(0) | NO | Not supported. The default value is NULL. |
| LAST_ANALYZED | date | NO | Not supported. The default value is NULL. |
| BUFFER_POOL | varchar(7) | NO | Not supported. The default value is NULL. |
| FLASH_CACHE | varchar(7) | NO | Not supported. The default value is NULL. |
| CELL_FLASH_CACHE | varchar(7) | NO | Not supported. The default value is NULL. |
| GLOBAL_STATS | varchar(3) | NO | Not supported. The default value is NULL. |
| USER_STATS | varchar(3) | NO | Not supported. The default value is NULL. |
| INTERVAL | varchar(3) | NO | Not supported. The default value is NO. |
| SEGMENT_CREATED | varchar(3) | NO | Not supported. The default value is NULL. |
| INDEXING | varchar(3) | NO | The default value is NULL. |
| READ_ONLY | varchar(3) | NO | The default value is NULL. |
| INMEMORY | varchar(8) | NO | The default value is NULL. |
| INMEMORY_PRIORITY | varchar(8) | NO | The default value is NULL. |
| INMEMORY_DISTRIBUTE | varchar(15) | NO | Not supported. The default value is NULL. |
| INMEMORY_COMPRESSION | varchar(17) | NO | The default value is NULL. |
| INMEMORY_DUPLICATE | varchar(13) | NO | The default value is NULL. |
| INMEMORY_SERVICE | varchar(12) | NO | The default value is NULL. |
| INMEMORY_SERVICE_NAME | varchar(1000) | NO | The default value is NULL. |
| CELLMEMORY | varchar(24) | NO | Not supported. The default value is NULL. |
| MEMOPTIMIZE_READ | varchar(8) | NO | The default value is NULL. |
| MEMOPTIMIZE_WRITE | varchar(8) | NO | The default value is NULL. |