Purpose
ALL_IND_PARTITIONS displays information about index partitions accessible to the current user in the database.
Related views
DBA_IND_PARTITIONS
USER_IND_PARTITIONS
Fields
| Field | 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 local index on a composite-partitioned table. Valid value: YES or NO. |
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the index. |
| SUBPARTITION_COUNT | NUMBER(38) | YES | The number of subpartitions. |
| HIGH_VALUE | VARCHAR2(1024) | NO | The expression for the value bound with the partition. |
| HIGH_VALUE_LENGTH | NUMBER | NO | The length of the expression for the value bound with the partition. |
| PARTITION_POSITION | NUMBER | NO | The position of the partition within the index. |
| STATUS | VARCHAR2(8) | NO | Indicates whether the index partition is usable. |
| TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace that contains the partition. |
| PCT_FREE | NUMBER | NO | The minimum percentage of available space in a block. At present, this field is not supported and is NULL by default. |
| INI_TRANS | NUMBER | NO | The initial number of transactions. At present, this field is not supported and is NULL by default. |
| MAX_TRANS | NUMBER | NO | The maximum number of transactions. At present, this field is not supported and is NULL by default. |
| INITIAL_EXTENT | NUMBER | NO | The size of the initial extent, in the unit of bytes. At present, this field is not supported and is NULL by default. |
| NEXT_EXTENT | NUMBER | NO | The size of secondary extents, in the unit of bytes. At present, this field is not supported and is NULL by default. |
| MIN_EXTENT | NUMBER | NO | The minimum number of extents allowed in the segment. At present, this field is not supported and is NULL by default. |
| MAX_EXTENT | NUMBER | NO | The maximum number of extents allowed in the segment. At present, this field is not supported and is NULL by default. |
| MAX_SIZE | NUMBER | NO | The maximum number of blocks allowed in the segment. At present, this field is not supported and is NULL by default. |
| PCT_INCREASE | NUMBER | NO | The percentage increase in the extent size. At present, this field is not supported and is NULL by default. |
| FREELISTS | NUMBER | NO | The number of process freelists that are allocated in the segment. At present, this field is not supported and is NULL by default. |
| FREELIST_GROUPS | NUMBER | NO | The number of process freelist groups that are allocated in the segment. At present, this field is not supported and is NULL by default. |
| LOGGING | VARCHAR2(7) | NO | Indicates whether logs are recorded for changes to the index. At present, this field is not supported and is NULL by default. |
| COMPRESSION | VARCHAR2(8) | NO | Indicates whether compression is enabled for the partitioned index. Valid values: ENABLE and DISABLE. |
| BLEVEL | NUMBER | 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 field is not supported and is NULL by default. |
| LEAF_BLOCKS | NUMBER | NO | The number of leaf blocks in the index partition. At present, this field is not supported and is NULL by default. |
| DISTINCT_KEYS | NUMBER | NO | The number of distinct keys in the index partition. At present, this field is not supported and is NULL by default. |
| AVG_LEAF_BLOCKS_PER_KEY | NUMBER | 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 fixed to 1 for indexes that enforce the UNIQUE and PRIMARY KEY constraints. At present, this field is not supported and is NULL by default. |
| AVG_DATA_BLOCKS_PER_KEY | NUMBER | 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 field is not supported and is NULL by default. |
| CLUSTERING_FACTOR | NUMBER | NO | The number of rows in the table based on the value of the index. At present, this field is not supported and is NULL by default. |
| NUM_ROWS | NUMBER | NO | The number of rows returned by the ANALYZE statement. At present, this field is not supported and is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | The sample size used in analyzing this partition. At present, this field 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 field is not supported and is NULL by default. |
| BUFFER_POOL | VARCHAR2(7) | NO | The actual buffer pool for the partition. At present, this field is not supported and is NULL by default. |
| FLASH_CACHE | VARCHAR2(7) | NO | The database smart flash cache hint for partition blocks. At present, this field is not supported and is NULL by default. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | The cell flash cache hint for partition blocks. At present, this field is not supported and is NULL by default. |
| USER_STATS | VARCHAR2(3) | NO | Indicates whether the statistical information was directly entered by the user. At present, this field is not supported and is NULL by default. |
| PCT_DIRECT_ACCESS | NUMBER | 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 field is not supported and is NULL by default. |
| GLOBAL_STATS | VARCHAR2(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 field is not supported and is NULL by default. |
| DOMIDX_OPSTATUS | VARCHAR2(6) | NO | The status of the operation on a domain index. At present, this field is not supported and is NULL by default. |
| PARAMETERS | VARCHAR2(1000) | NO | The parameter string for a domain index. At present, this field is not supported and is NULL by default. |
| INTERVAL | VARCHAR2(3) | NO | Indicates whether the partition is in the interval section of an interval partitioned table or in the range section. At present, this field is not supported and is NULL by default. |
| SEGMENT_CREATED | VARCHAR2(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 field is not supported and is NULL by default. |
