Purpose
The oceanbase.DBA_IND_PARTITIONS view displays the information about the partitions and subpartitions of an index.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| INDEX_OWNER | varchar(128) | NO | The owner of the index. |
| INDEX_NAME | varchar(128) | NO | The name of the index. |
| COMPOSITE | varchar(3) | NO | Indicates whether a partition belongs to the local index of the composite-partitioned table. |
| PARTITION_NAME | varchar(128) | NO | The name of the partition. |
| SUBPARTITION_COUNT | bigint(20) | NO | The number of subpartitions. |
| HIGH_VALUE | mediumtext | NO | The expression for the value bound with the partition. |
| HIGH_VALUE_LENGTH | bigint(20) | NO | The length of the expression for the value bound with the partition. |
| PARTITION_POSITION | bigint(20) | NO | The position of the partition within the index. |
| STATUS | varchar(8) | NO | Indicates whether the index partition is usable. |
| TABLESPACE_NAME | varchar(30) | NO | The name of the tablespace that contains the partition. |
| PCT_FREE | bigint(0) | NO | The minimum percentage of available space in a block. At present, this column is not supported and is NULL by default. |
| INI_TRANS | bigint(0) | NO | The initial number of transactions. At present, this column is not supported and is NULL by default. |
| MAX_TRANS | bigint(0) | NO | The maximum number of transactions. At present, this column is not supported and is NULL by default. |
| INITIAL_EXTENT | bigint(0) | NO | The size of the initial extent, in the unit of bytes. At present, this column is not supported and is NULL by default. |
| NEXT_EXTENT | bigint(0) | NO | The size of secondary extents, in the unit of bytes. At present, this column is not supported and is NULL by default. |
| MIN_EXTENT | bigint(0) | NO | The minimum number of extents allowed in the segment. At present, this column is not supported and is NULL by default. |
| MAX_EXTENT | bigint(0) | NO | The maximum number of extents allowed in the segment. At present, this column is not supported and is NULL by default. |
| MAX_SIZE | bigint(0) | NO | The maximum number of blocks allowed in the segment. At present, this column is not supported and is NULL by default. |
| PCT_INCREASE | bigint(0) | NO | The percentage increase in the extent size. At present, this column is not supported and is NULL by default. |
| FREELISTS | bigint(0) | NO | The number of process freelists that are allocated in the segment. At present, this column is not supported and is NULL by default. |
| FREELIST_GROUPS | bigint(0) | NO | The number of process freelist groups that are allocated in the segment. At present, this column is not supported and is NULL by default. |
| LOGGING | varchar(7) | NO | Indicates whether logs are recorded for changes to the index. At present, this column is not supported and is NULL by default. |
| COMPRESSION | varchar(13) | NO | Indicates whether compression is enabled for the partitioned index. Valid values: |
| BLEVEL | bigint(0) | NO | The B*-tree level, that is, the depth of the index from its root block to its leaf blocks. A depth of 0 indicates that the root block and the leaf blocks are the same. At present, this column is not supported and is NULL by default. |
| LEAF_BLOCKS | bigint(0) | NO | The number of leaf blocks in the index partition. At present, this column is not supported and is NULL by default. |
| DISTINCT_KEYS | bigint(0) | NO | The number of distinct keys in the index partition. At present, this column is not supported and is NULL by default. |
| AVG_LEAF_BLOCKS_PER_KEY | bigint(0) | NO | The average number of leaf blocks in which each distinct value in the index appears. The value is rounded to the nearest integer. The value is always 1 for indexes that enforce the UNIQUE and PRIMARY KEY constraints. At present, this column is not supported and is NULL by default. |
| AVG_DATA_BLOCKS_PER_KEY | bigint(0) | NO | The average number of data blocks in the table that are pointed to by different values in the index that are rounded to the nearest integer. This statistical data is the average number of data blocks containing rows that have a specified value for the indexed columns. At present, this column is not supported and is NULL by default. |
| CLUSTERING_FACTOR | bigint(0) | NO | The number of rows in the table based on the value of the index. At present, this column is not supported and is NULL by default. |
| NUM_ROWS | bigint(0) | NO | The number of rows returned by the ANALYZE statement. At present, this column is not supported and is NULL by default. |
| SAMPLE_SIZE | bigint(0) | NO | The sample size used in analyzing this partition. At present, this column is not supported and is NULL by default. |
| LAST_ANALYZED | date | NO | The most recent date on which this partition was analyzed. At present, this column is not supported and is NULL by default. |
| BUFFER_POOL | varchar(7) | NO | The actual buffer pool for the partition. At present, this column is not supported and is NULL by default. |
| FLASH_CACHE | varchar(7) | NO | The database smart flash cache hint for partition blocks. At present, this column is not supported and is NULL by default. |
| CELL_FLASH_CACHE | varchar(7) | NO | The cell flash cache hint for partition blocks. At present, this column is not supported and is NULL by default. |
| USER_STATS | varchar(3) | NO | Indicates whether the statistical information was directly entered by the user. At present, this column is not supported and is NULL by default. |
| PCT_DIRECT_ACCESS | bigint(0) | NO | If the index is a secondary index on an index-organized table, the value is the percentage of rows with valid guesses. At present, this column is not supported and is NULL by default. |
| GLOBAL_STATS | varchar(3) | NO | Indicates whether the statistics on the partition were collected for the partition as a whole or estimated based on the statistics on underlying subpartitions. At present, this column is not supported and is NULL by default. |
| DOMIDX_OPSTATUS | varchar(6) | NO | The status of the operation on a domain index. At present, this column is not supported and is NULL by default. |
| PARAMETERS | text | NO | The parameter string for a domain index. At present, this column is not supported and is NULL by default. |
| INTERVAL | varchar(3) | NO | Indicates whether the partition is in the interval section of an interval partitioned table or in the range section. At present, this column is not supported and is NULL by default. |
| SEGMENT_CREATED | varchar(3) | NO | Indicates whether a segment has been created for the index partition. The value N/A indicates that the index has been divided and no segment exists at the partition level. At present, this column is not supported and is NULL by default. |
| ORPHANED_ENTRIES | varchar(3) | NO | Indicates whether the global index partition contains obsolete entries because index maintenance is delayed by the DROP/TRUNCATE PARTITION or MODIFY PARTITION INDEXING OFF operation. Valid values:YES: The index partition contains orphaned entries.NO: The index partition does not contain orphaned entries. |