Note
This view is available starting with V2.2.30.
Purpose
This view displays information about the index partitions that are accessible to the current user.
Applicability
This view is available only in Oracle-compatible mode of OceanBase Database.
Columns
| Column | Type | Nullable | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| INDEX_OWNER | VARCHAR2(128) | NO | The owner of the index. | ||||||||||
| INDEX_NAME | VARCHAR2(128) | NO | The name of the index. | ||||||||||
| COMPOSITE | VARCHAR2(3) | NO | Indicates whether the partition belongs to a composite-partitioned table's local index:
|
||||||||||
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the partition. | ||||||||||
| SUBPARTITION_COUNT | NUMBER | NO | The number of subpartitions. | ||||||||||
| HIGH_VALUE | VARCHAR2(32767) | NO | The expression of the partition bound value. | ||||||||||
| HIGH_VALUE_LENGTH | NUMBER | NO | The length of the partition bound value expression. | ||||||||||
| PARTITION_POSITION | NUMBER | NO | The position of the partition in the index. | ||||||||||
| STATUS | VARCHAR2(8) | NO | Indicates whether the index partition is available. | ||||||||||
| TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace that contains the partition. | ||||||||||
| PCT_FREE | NUMBER | NO | This column is not supported. It is set to NULL by default. | ||||||||||
| INI_TRANS | NUMBER | NO | This column is not supported. It is set to NULL by default. | ||||||||||
| MAX_TRANS | NUMBER | NO | This column is not supported. It is set to NULL by default. | ||||||||||
| INITIAL_EXTENT | NUMBER | NO | This column is not supported. It is set to NULL by default. | ||||||||||
| NEXT_EXTENT | NUMBER | NO | This column is not supported. It is set to NULL by default. | ||||||||||
| MIN_EXTENT | NUMBER | NO | This column is not supported. It is set to NULL by default. | ||||||||||
| MAX_EXTENT | NUMBER | NO | This column is not supported. It is set to NULL by default. | ||||||||||
| MAX_SIZE | NUMBER | NO | This column is not supported. It is set to NULL by default. | ||||||||||
| PCT_INCREASE | NUMBER | NO | This column is not supported. It is set to NULL by default. | ||||||||||
| FREELISTS | NUMBER | NO | This column is not supported. It is set to NULL by default. | ||||||||||
| FREELIST_GROUPS | NUMBER | NO | This column is not supported. It is set to NULL by default. | ||||||||||
| LOGGING | VARCHAR2(7) | NO | This column is not supported. It is set to NULL by default. | ||||||||||
| COMPRESSION | VARCHAR2(13) | NO | Indicates whether the partition index is compressed:
|
||||||||||
| BLEVEL | NUMBER | NO | This column is not supported. It is set to NULL by default. | ||||||||||
| LEAF_BLOCKS | NUMBER | NO | This column is not supported. It is set to NULL by default. | ||||||||||
| DISTINCT_KEYS | NUMBER | NO | This column is not supported. It is set to NULL by default. | ||||||||||
| AVG_LEAF_BLOCKS_PER_KEY | NUMBER | NO | This column is reserved. | ||||||||||
| AVG_DATA_BLOCKS_PER_KEY | NUMBER | NO | This column is unavailable and is set to NULL by default. | ||||||||||
| CLUSTERING_FACTOR | NUMBER | NO | Currently, this column is not supported and defaults to NULL | ||||||||||
| NUM_ROWS | NUMBER | NO | This column is not supported. Currently, it is set to NULL. | ||||||||||
| SAMPLE_SIZE | NUMBER | NO | This column is not supported. It will be NULL by default. | ||||||||||
| LAST_ANALYZED | DATE | NO | This column is not supported currently and is always NULL. | ||||||||||
| BUFFER_POOL | VARCHAR2(7) | NO | The column is not supported in OceanBase Database and will be NULL by default. | ||||||||||
| FLASH_CACHE | VARCHAR2(7) | NO | This column is not currently supported. The default value is NULL. | ||||||||||
| COLUMN | TYPE | NULLABLE | DESCRIPTION | --------------------------- | ---------------- | ---------------- | ------------------------------------------ | CELL_FLASH_CACHE | VARCHAR2(7) | NO | The value of this column is currently NULL. | ||
| USER_STATS | VARCHAR2(3) | NO | The value of this column is null, and currently not supported. | ||||||||||
| PCT_DIRECT_ACCESS | NUMBER | NO | This column is not supported and is always NULL. | ||||||||||
| GLOBAL_STATS | VARCHAR2(3) | NO | Currently, this column is not supported and defaults to NULL. | ||||||||||
| DOMIDX_OPSTATUS | VARCHAR2(6) | NO | This column is not supported. Currently, its value is NULL by default. | ||||||||||
| PARAMETER | VARCHAR2(1000) | NO | Currently, this parameter is not supported and its value defaults to NULL | ||||||||||
| INTERVAL | VARCHAR2(3) | NO | This column is not supported at present and is NO by default. |
||||||||||
| COLUMN | DATA TYPE | NULLABLE | DESCRIPTION | -------------------------- | ---------------- | -------------- | ------------------------------------------- | SEGMENT_CREATED | VARCHAR2(3) | NO | The value of this column is null. | ||
| ORPHANED_ENTRIES | VARCHAR2(3) | NO | This column is currently not supported, and its default value is NULL. |
Sample query
Query all index partitions in the databases that the current user can access.
obclient [SYS]> SELECT * FROM ALL_IND_PARTITIONS\G
The query result is as follows:
obclient [SYS]> SELECT * FROM ALL_IND_PARTITIONS\G
*************************** 1. row ***************************
INDEX_OWNER: SYS
INDEX_NAME: TBL2_F_RL_IDX1
COMPOSITE: YES
PARTITION_NAME: P0
SUBPARTITION_COUNT: 3
HIGH_VALUE: 100
HIGH_VALUE_LENGTH: 3
PARTITION_POSITION: 1
STATUS: NULL
TABLESPACE_NAME: NULL
PCT_FREE: NULL
INI_TRANS: NULL
MAX_TRANS: NULL
INITIAL_EXTENT: NULL
NEXT_EXTENT: NULL
MIN_EXTENT: NULL
MAX_EXTENT: NULL
MAX_SIZE: NULL
PCT_INCREASE: NULL
FREELISTS: NULL
FREELIST_GROUPS: NULL
LOGGING: NULL
COMPRESSION: DISABLED
BLEVEL: NULL
LEAF_BLOCKS: NULL
DISTINCT_KEYS: NULL
AVG_LEAF_BLOCKS_PER_KEY: NULL
AVG_DATA_BLOCKS_PER_KEY: NULL
CLUSTERING_FACTOR: NULL
NUM_ROWS: NULL
SAMPLE_SIZE: NULL
LAST_ANALYZED: NULL
BUFFER_POOL: NULL
FLASH_CACHE: NULL
CELL_FLASH_CACHE: NULL
USER_STATS: NULL
PCT_DIRECT_ACCESS: NULL
GLOBAL_STATS: NULL
DOMIDX_OPSTATUS: NULL
PARAMETERS: NULL
INTERVAL: NO
SEGMENT_CREATED: NULL
ORPHANED_ENTRIES: NULL
*************************** 2. row ***************************
INDEX_OWNER: SYS
INDEX_NAME: TBL2_F_RL_IDX1
COMPOSITE: YES
PARTITION_NAME: P1
SUBPARTITION_COUNT: 3
HIGH_VALUE: 200
HIGH_VALUE_LENGTH: 3
PARTITION_POSITION: 2
STATUS: NULL
TABLESPACE_NAME: NULL
PCT_FREE: NULL
INI_TRANS: NULL
MAX_TRANS: NULL
INITIAL_EXTENT: NULL
NEXT_EXTENT: NULL
MIN_EXTENT: NULL
MAX_EXTENT: NULL
MAX_SIZE: NULL
PCT_INCREASE: NULL
FREELISTS: NULL
FREELIST_GROUPS: NULL
LOGGING: NULL
COMPRESSION: DISABLED
BLEVEL: NULL
LEAF_BLOCKS: NULL
DISTINCT_KEYS: NULL
AVG_LEAF_BLOCKS_PER_KEY: NULL
AVG_DATA_BLOCKS_PER_KEY: NULL
CLUSTERING_FACTOR: NULL
NUM_ROWS: NULL
SAMPLE_SIZE: NULL
LAST_ANALYZED: NULL
BUFFER_POOL: NULL
FLASH_CACHE: NULL
CELL_FLASH_CACHE: NULL
USER_STATS: NULL
PCT_DIRECT_ACCESS: NULL
GLOBAL_STATS: NULL
DOMIDX_OPSTATUS: NULL
PARAMETERS: NULL
INTERVAL: NO
SEGMENT_CREATED: NULL
ORPHANED_ENTRIES: NULL
2 rows in set