Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_CLUSTERS Description of clusters accessible to the user

Column ID Column name Data type Length Precision NULL Description
1OWNERVARCHAR230(null)NOwner of the cluster
2CLUSTER_NAMEVARCHAR230(null)NName of the cluster
3TABLESPACE_NAMEVARCHAR230(null)NName of the tablespace containing the cluster
4PCT_FREENUMBER22(null)YMinimum percentage of free space in a block
5PCT_USEDNUMBER22(null)YMinimum percentage of used space in a block
6KEY_SIZENUMBER22(null)YEstimated size of cluster key plus associated rows
7INI_TRANSNUMBER22(null)NInitial number of transactions
8MAX_TRANSNUMBER22(null)NMaximum number of transactions
9INITIAL_EXTENTNUMBER22(null)YSize of the initial extent in bytes
10NEXT_EXTENTNUMBER22(null)YSize of secondary extents in bytes
11MIN_EXTENTSNUMBER22(null)NMinimum number of extents allowed in the segment
12MAX_EXTENTSNUMBER22(null)NMaximum number of extents allowed in the segment
13PCT_INCREASENUMBER22(null)YPercentage increase in extent size
14FREELISTSNUMBER22(null)YNumber of process freelists allocated in this segment
15FREELIST_GROUPSNUMBER22(null)YNumber of freelist groups allocated in this segment
16AVG_BLOCKS_PER_KEYNUMBER22(null)YAverage number of blocks containing rows with a given cluster key
17CLUSTER_TYPEVARCHAR25(null)YType of cluster: b-tree index or hash
18FUNCTIONVARCHAR215(null)YIf a hash cluster, the hash function
19HASHKEYSNUMBER22(null)YIf a hash cluster, the number of hash keys (hash buckets)
20DEGREEVARCHAR210(null)YThe number of threads per instance for scanning the cluster
21INSTANCESVARCHAR210(null)YThe number of instances across which the cluster is to be scanned
22CACHEVARCHAR25(null)YWhether the cluster is to be cached in the buffer cache
23BUFFER_POOLVARCHAR27(null)YThe default buffer pool to be used for cluster blocks
24SINGLE_TABLEVARCHAR25(null)YWhether the cluster can contain only a single table
25DEPENDENCIESVARCHAR28(null)YShould we keep track of row level dependencies?

Index | Home | Forums

This page was created by oracleabc.com on Dec 31,2007 18:49:22
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here