DBA_CLUSTERS describes all clusters in the database. Its columns are the same as those in "ALL_CLUSTERS".
· ALL_CLUSTERS describes all clusters accessible to the current user.
· USER_CLUSTERS describes all clusters owned by the current user. This view does not display the OWNER 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 cluster: B*-Tree index or hash |
|
|
| | If a hash cluster, the hash function |
|
|
| | If a hash cluster, the number of hash keys (hash buckets) |
|
|
| | Number of threads per instance for scanning the cluster |
|
|
| | Number of instances across which the cluster is to be scanned |
|
|
| | Indicates whether the cluster is to be cached in the buffer cache ( |
|
|
| | Default buffer pool for the cluster |
|
|
| | Indicates whether this is a single-table cluster ( |
|
|
| | Indicates whether row-level dependency tracking is enabled ( |
No comments:
Post a Comment