eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_CLUSTERS

Object Details

Object Name:	DBA_CLUSTERS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Description of all clusters in the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the cluster
CLUSTER_NAME	VARCHAR2	(128)	Yes	Name of the cluster
TABLESPACE_NAME	VARCHAR2	(30)	Yes	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		Yes	Initial number of transactions
MAX_TRANS	NUMBER		Yes	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		Yes	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER		Yes	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER			Percentage increase in extent size
FREELISTS	NUMBER			Number of process freelists allocated in this segment
FREELIST_GROUPS	NUMBER			Number of freelist groups allocated in this segment
AVG_BLOCKS_PER_KEY	NUMBER			Average number of blocks containing rows with a given cluster key
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)		The number of threads per instance for scanning the cluster
INSTANCES	VARCHAR2	(10)		The 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
BUFFER_POOL	VARCHAR2	(7)		The default buffer pool to be used for cluster blocks
FLASH_CACHE	VARCHAR2	(7)		The default flash cache hint to be used for cluster blocks
CELL_FLASH_CACHE	VARCHAR2	(7)		The default cell flash cache hint to be used for cluster blocks
SINGLE_TABLE	VARCHAR2	(5)		Whether the cluster can contain only a single table
DEPENDENCIES	VARCHAR2	(8)		Should we keep track of row level dependencies?

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      CLUSTER_NAME
,      TABLESPACE_NAME
,      PCT_FREE
,      PCT_USED
,      KEY_SIZE
,      INI_TRANS
,      MAX_TRANS
,      INITIAL_EXTENT
,      NEXT_EXTENT
,      MIN_EXTENTS
,      MAX_EXTENTS
,      PCT_INCREASE
,      FREELISTS
,      FREELIST_GROUPS
,      AVG_BLOCKS_PER_KEY
,      CLUSTER_TYPE
,      FUNCTION
,      HASHKEYS
,      DEGREE
,      INSTANCES
,      CACHE
,      BUFFER_POOL
,      FLASH_CACHE
,      CELL_FLASH_CACHE
,      SINGLE_TABLE
,      DEPENDENCIES
FROM SYS.DBA_CLUSTERS;

Dependencies

[top of page]

SYS.DBA_CLUSTERS references the following:

SYS: INT$DBA_CLUSTERS

SYS.DBA_CLUSTERS is referenced by following:

PUBLIC: DBA_CLUSTERS
SYS: DBMS_SQLTCB_INTERNAL - show dependent code