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