DBA_CLUSTERS

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