Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_CLUSTERS

ALL_CLUSTERS describes all clusters accessible to the current user.

Related Views

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   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   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)
Indicates whether the cluster is to be cached in the buffer cache (Y) or not (N)
BUFFER_POOL VARCHAR2(7)
Default buffer pool for the cluster
SINGLE_TABLE VARCHAR2(5)
Indicates whether this is a single-table cluster (Y) or not (N)
DEPENDENCIES VARCHAR2(8)   Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED)