Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
This view displays the names of subpartitions, tables, and partitions to which subpartitions belong, as well as 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 of the subpartition. |
| HIGH_VALUE_LENGTH | bigint(20) | NO | The length of the subpartition expression. |
| 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 value of this field is NULL. |
| PCT_USED | bigint(0) | NO | Not supported. The value of this field is NULL. |
| INI_TRANS | bigint(0) | NO | Not supported. The value of this field is NULL. |
| MAX_TRANS | bigint(0) | NO | Not supported. The value of this field is NULL. |
| INITIAL_EXTENT | bigint(0) | NO | Not supported. The value of this field is NULL. |
| NEXT_EXTENT | bigint(0) | NO | Not supported. The value of this field is NULL. |
| MIN_EXTENT | bigint(0) | NO | Not supported. The value of this field is NULL. |
| MAX_EXTENT | bigint(0) | NO | Not supported. The value of this field is NULL. |
| MAX_SIZE | bigint(0) | NO | Not supported. The value of this field is NULL. |
| PCT_INCREASE | bigint(0) | NO | Not supported. The value of this field is NULL. |
| FREELISTS | bigint(0) | NO | Not supported. The value of this field is NULL. |
| FREELIST_GROUPS | bigint(0) | NO | Not supported. The value of this field is NULL. |
| LOGGING | varchar(3) | NO | Not supported. The value of this field 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 value of this field is NULL. |
| BLOCKS | bigint(0) | NO | Not supported. The value of this field is NULL. |
| EMPTY_BLOCKS | bigint(0) | NO | Not supported. The value of this field is NULL. |
| AVG_SPACE | bigint(0) | NO | Not supported. The value of this field is NULL. |
| CHAIN_CNT | bigint(0) | NO | Not supported. The value of this field is NULL. |
| AVG_ROW_LEN | bigint(0) | NO | Not supported. The value of this field is NULL. |
| SAMPLE_SIZE | bigint(0) | NO | Not supported. The value of this field is NULL. |
| LAST_ANALYZED | date | NO | Not supported. The value of this field is NULL. |
| BUFFER_POOL | varchar(7) | NO | Not supported. The value of this field is NULL. |
| FLASH_CACHE | varchar(7) | NO | Not supported. The value of this field is NULL. |
| CELL_FLASH_CACHE | varchar(7) | NO | Not supported. The value of this field is NULL. |
| GLOBAL_STATS | varchar(3) | NO | Not supported. The value of this field is NULL. |
| USER_STATS | varchar(3) | NO | Not supported. The value of this field is NULL. |
| INTERVAL | varchar(3) | NO | Not supported. The value of this field is NO. |
| SEGMENT_CREATED | varchar(3) | NO | Not supported. The value of this field is NULL. |
| INDEXING | varchar(3) | NO | The value of this field is NULL. |
| READ_ONLY | varchar(3) | NO | The value of this field is NULL. |
| INMEMORY | varchar(8) | NO | The value of this field is NULL. |
| INMEMORY_PRIORITY | varchar(8) | NO | The value of this field is NULL. |
| INMEMORY_DISTRIBUTE | varchar(15) | NO | Not supported. The value of this field is NULL. |
| INMEMORY_COMPRESSION | varchar(17) | NO | The value of this field is NULL. |
| INMEMORY_DUPLICATE | varchar(13) | NO | The value of this field is NULL. |
| INMEMORY_SERVICE | varchar(12) | NO | The value of this field is NULL. |
| INMEMORY_SERVICE_NAME | varchar(1000) | NO | The value of this field is NULL. |
| CELLMEMORY | varchar(24) | NO | Not supported. The value of this field is NULL. |
| MEMOPTIMIZE_READ | varchar(8) | NO | The value of this field is NULL. |
| MEMOPTIMIZE_WRITE | varchar(8) | NO | The value of this field is NULL. |