DBA_INDEXES
Tespaces libres (trous) dans les tablespaces.
| Nom de la colonne | Description |
| AVG_LEAF_BLOCKS_PER_KEY | The average number of leaf blocks per key |
| AVG_DATA_BLOCKS_PER_KEY | The average number of data blocks per key |
| CLUSTERING_FACTOR |
A measurement of the amount of (dis)order of the table this index is for
|
| STATUS | Whether index is in Direct Load State |
| OWNER | Username of the owner of the index |
| INDEX_NAME | Name of the index |
| TABLE_OWNER | Owner of the indexed object |
| TABLE_NAME | Name of the indexed object |
| TABLE_TYPE | Type of the indexed object |
| UNIQUENESS | Uniqueness status of the index: UNIQUE or NONUNIQUE |
| TABLESPACE_NAME | Name of the tablespace containing the index |
| INI_TRANS | Initial number of transactions |
| MAX_TRANS | Maximum number of transactions |
| INITIAL_EXTENT | Size of the initial extent |
| NEXT_EXTENT | Size of secondary extents |
| MIN_EXTENTS | Minimum number of extents allowed in the segment |
| PCT_INCREASE | Percentage increase in extent size |
| FREELISTS | Number of process freelists allocated to this segment |
| PCT_FREE | Minimum percentage of free space in a block |
| BLEVEL |
B-Tree
level: depth of the index from its root block to its leaf blocks. A depth of
0 indicates that the root block and leaf block are the same.
|
| LEAF_BLOCKS | The number of leaf blocks in the index |
| DISTINCT_KEYS | The number of distinct keys in the index |