Table: ALL_CLUSTERS
Description of clusters accessible to the user
| Column Name | Description |
|---|---|
| AVG_BLOCKS_PER_KEY | Average number of blocks containing rows with a given cluster key |
| BUFFER_POOL | The default buffer pool to be used for cluster blocks |
| CACHE | Whether the cluster is to be cached in the buffer cache |
| CLUSTER_NAME | Name of the cluster |
| CLUSTER_TYPE | Type of cluster: b-tree index or hash |
| DEGREE | The number of threads per instance for scanning the cluster |
| DEPENDENCIES | Should we keep track of row level dependencies? |
| FREELISTS | Number of process freelists allocated in this segment |
| FREELIST_GROUPS | Number of freelist groups allocated in this segment |
| FUNCTION | If a hash cluster, the hash function |
| HASHKEYS | If a hash cluster, the number of hash keys (hash buckets) |
| INITIAL_EXTENT | Size of the initial extent in bytes |
| INI_TRANS | Initial number of transactions |
| INSTANCES | The number of instances across which the cluster is to be scanned |
| KEY_SIZE | Estimated size of cluster key plus associated rows |
| MAX_EXTENTS | Maximum number of extents allowed in the segment |
| MAX_TRANS | Maximum number of transactions |
| MIN_EXTENTS | Minimum number of extents allowed in the segment |
| NEXT_EXTENT | Size of secondary extents in bytes |
| OWNER | Owner of the cluster |
| PCT_FREE | Minimum percentage of free space in a block |
| PCT_INCREASE | Percentage increase in extent size |
| PCT_USED | Minimum percentage of used space in a block |
| SINGLE_TABLE | Whether the cluster can contain only a single table |
| TABLESPACE_NAME | Name of the tablespace containing the cluster |