home - keyword index

Table: DBA_CLUSTERS

Description of all clusters in the database

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

home - keyword index

Comment on this page: