Purpose
ALL_IND_SUBPARTITIONS displays information about all the index subpartitions accessible to the current user in the database.
Related views
DBA_IND_SUBPARTITIONS
USER_IND_SUBPARTITIONS
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. |
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the partition. |
| SUBPARTITION_NAME | VARCHAR2(128) | NO | The name of the subpartition. |
| HIGH_VALUE | VARCHAR2(1024) | NO | The expression for the value bound with the subpartition. |
| HIGH_VALUE_LENGTH | NUMBER | NO | The length of the expression for the value bound with the subpartition. |
| SUBPARTITION_POSITION | NUMBER | NO | The position of a subpartition in a partition. |
| 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. 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 in the index subpartition. At present, this field is not supported and is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | The sample size used in analyzing this subpartition. 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 default buffer pool for the subpartition. At present, this field is not supported and is NULL by default. |
| FLASH_CACHE | VARCHAR2(7) | NO | The database smart flash cache hint for subpartition 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 subpartition 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 | |
| DOMIDX_OPSTATUS | VARCHAR(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. The value is YES if the partition is in the interval section, and is NO if the partition is in the range section. At present, this field is not supported and is NULL by default. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | Indicates whether the index subpartition segment has been created. The value N/A indicates that the index is not subpartitioned. At present, this field is not supported and is NULL by default. |