ALL_CLUSTERS

Description of clusters accessible to the user

Columns
   ___________________________
 
   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
   INI_TRANS
      Initial number of transactions
   MAX_TRANS
      Maximum number of transactions
   INITIAL_EXTENT
      Size of the initial extent in bytes ALL_CLUSTERS
   MIN_EXTENTS
      Minimum number of extents allowed in the segment
   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
   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
   INSTANCES
      The number of instances across which the cluster is to be scanned
   CACHE
      Whether the cluster is to be cached in the buffer cache
   BUFFER_POOL
      The default buffer pool to be used for cluster blocks
   SINGLE_TABLE
      Whether the cluster can contain only a single table
   DEPENDENCIES
      Should we keep track of row level dependencies?


© Copyright SS64.com 1999-2014
Some rights reserved