|
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) |
