USER_CLUSTERS

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

Related Commands: