ALL_CLUSTERS

ALL_CLUSTERS describes all clusters accessible to the user.

Related Views

• DBA_CLUSTERS describes all clusters in the database.

• USER_CLUSTERS describes all clusters owned by the current user. This view does not display the OWNER column.

  Column	Datatype	NULL	Description
  OWNER	VARCHAR2(30)	NOT NULL	Owner of the cluster
  CLUSTER_NAME	VARCHAR2(30)	NOT NULL	Name of the cluster
  TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the cluster
  PCT_FREE	NUMBER		Minimum percentage of free space in a block
  PCT_USED	NUMBER	NOT NULL	Minimum percentage of used space in a block
  KEY_SIZE	NUMBER		Estimated size of cluster key plus associated rows
  INI_TRANS	NUMBER	NOT NULL	Initial number of transactions
  MAX_TRANS	NUMBER	NOT NULL	Maximum number of transactions
  INITIAL_EXTENT	NUMBER		Size of the initial extent in bytes
  NEXT_EXTENT	NUMBER		Size of secondary extents in bytes
  MIN_EXTENTS	NUMBER	NOT NULL	Minimum number of extents allowed in the segment
  MAX_EXTENTS	NUMBER	NOT NULL	Maximum number of extents allowed in the segment
  PCT_INCREASE	NUMBER	NOT NULL	Percentage increase in extent size
  FREELISTS	NUMBER		Number of process freelists allocated to this segment
  FREELIST_GROUPS	NUMBER		Number of freelist groups allocated to this segment
  AVG_BLOCKS_PER_KEY	NUMBER		Number of blocks in the table divided by number of cluster keys
  CLUSTER_TYPE	VARCHAR2(5)		Type of cluster: B*-Tree index or hash
  FUNCTION	VARCHAR2(15)		If a hash cluster, the hash function
  HASHKEYS	NUMBER		If a hash cluster, the number of hash keys (hash buckets)
  DEGREE	VARCHAR2(10)		Number of threads per instance for scanning the cluster
  INSTANCES	VARCHAR2(10)		Number of instances across which the cluster is to be scanned
  CACHE	VARCHAR2(5)		Whether the cluster is to be cached in the buffer cache (CACHE | NOCACHE)
  BUFFER_POOL	VARCHAR2(7)		Default buffer pool for the cluster
  SINGLE_TABLE	VARCHAR2(5)		Whether this is a single-table cluster (Y | N)