OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the cluster |
CLUSTER_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the cluster |
TABLESPACE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the tablespace containing the cluster |
PCT_FREE |
NUMBER |
|
Minimum percentage of free space in a block |
PCT_USED |
NUMBER |
NOT NULL |
Minimum percentage of used space in a block |
KEY_SIZE |
NUMBER |
|
Estimated size of cluster key plus associated rows |
INI_TRANS |
NUMBER |
NOT NULL |
Initial number of transactions |
MAX_TRANS |
NUMBER |
NOT NULL |
Maximum number of transactions |
INITIAL_EXTENT |
NUMBER |
|
Size of the initial extent in bytes |
NEXT_EXTENT |
NUMBER |
|
Size of secondary extents in bytes |
MIN_EXTENTS |
NUMBER |
NOT NULL |
Minimum number of extents allowed in the segment |
MAX_EXTENTS |
NUMBER |
NOT NULL |
Maximum number of extents allowed in the segment |
PCT_INCREASE |
NUMBER |
NOT NULL |
Percentage increase in extent size |
FREELISTS |
NUMBER |
|
Number of process freelists allocated to this segment |
FREELIST_GROUPS |
NUMBER |
|
Number of freelist groups allocated to this segment |
AVG_BLOCKS_PER_KEY |
NUMBER |
|
Number of blocks in the table divided by number of hash keys |
CLUSTER_TYPE |
VARCHAR2(5) |
|
Type of cluster: B*-Tree index or hash |
FUNCTION |
VARCHAR2(15) |
|
If a hash cluster, the hash function |
HASHKEYS |
NUMBER |
|
If a hash cluster, the number of hash keys (hash buckets) |
DEGREE |
VARCHAR2(10) |
|
Number of threads per instance for scanning the cluster |
INSTANCES |
VARCHAR2(10) |
|
Number of instances across which the cluster is to be scanned |
CACHE |
VARCHAR2(5) |
|
Whether the cluster is to be cached in the buffer cache (CACHE | NOCACHE) |
BUFFER_POOL |
VARCHAR2(7) |
|
Default buffer pool for the cluster |
SINGLE_TABLE |
VARCHAR2(5) |
|
Whether this is a single-table cluster (Y or N) |