ALL_CLUSTERS

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