2.80 ALL_CLUSTERS
ALL_CLUSTERS
describes all clusters accessible to the current 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 theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the cluster |
|
|
|
Name of the cluster |
|
|
|
Name of the tablespace containing the cluster |
|
|
|
Minimum percentage of free space in a block |
|
|
|
Minimum percentage of used space in a block |
|
|
|
Estimated size of cluster key plus associated rows |
|
|
|
Initial number of transactions |
|
|
|
Maximum number of transactions |
|
|
|
Size of the initial extent in bytes |
|
|
|
Size of secondary extents in bytes |
|
|
|
Minimum number of extents allowed in the segment |
|
|
|
Maximum number of extents allowed in the segment |
|
|
|
Percentage increase in extent size |
|
|
|
Number of process freelists allocated to this segment |
|
|
|
Number of freelist groups allocated to this segment |
|
|
|
Number of blocks in the table divided by number of cluster keys |
|
|
|
Type of the cluster:
|
|
|
|
If the cluster is a hash cluster, the hash function |
|
|
|
If the cluster is a hash cluster, the number of hash keys (hash buckets) |
|
|
|
Number of threads per instance for scanning the cluster, or |
|
|
|
Number of instances across which the cluster is to be scanned , or |
|
|
|
Indicates whether the cluster is to be cached in the buffer cache ( |
|
|
|
Buffer pool to be used for cluster blocks:
|
|
|
|
Database Smart Flash Cache hint to be used for cluster blocks:
Solaris and Oracle Linux functionality only. |
|
|
|
Cell flash cache hint to be used for cluster blocks:
See Also: Oracle Exadata Storage Server Software documentation for more information |
|
|
|
Indicates whether this is a single-table cluster ( |
|
|
|
Indicates whether row-level dependency tracking is enabled ( |
See Also: