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_IND_STATISTICS

Object Details

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

Optimizer statistics for all indexes in the database

[View Source]

Columns

Name	Datatype	Length	Comments
OWNER	VARCHAR2	(128)	Username of the owner of the index
INDEX_NAME	VARCHAR2	(128)	Name of the index
TABLE_OWNER	VARCHAR2	(128)	Owner of the indexed object
TABLE_NAME	VARCHAR2	(128)	Name of the indexed object
PARTITION_NAME	VARCHAR2	(128)	Name of the partition
PARTITION_POSITION	NUMBER		Position of the partition within index
SUBPARTITION_NAME	VARCHAR2	(128)	Name of the subpartition
SUBPARTITION_POSITION	NUMBER		Position of the subpartition within partition
OBJECT_TYPE	VARCHAR2	(12)	Type of the object (INDEX, PARTITION, SUBPARTITION)
BLEVEL	NUMBER		B-Tree level
LEAF_BLOCKS	NUMBER		The number of leaf blocks in the index
DISTINCT_KEYS	NUMBER		The number of distinct keys in the index
AVG_LEAF_BLOCKS_PER_KEY	NUMBER		The average number of leaf blocks per key
AVG_DATA_BLOCKS_PER_KEY	NUMBER		The average number of data blocks per key
CLUSTERING_FACTOR	NUMBER		A measurement of the amount of (dis)order of the table this index is for
NUM_ROWS	NUMBER		The number of rows in the index
AVG_CACHED_BLOCKS	NUMBER		Average number of blocks in buffer cache
AVG_CACHE_HIT_RATIO	NUMBER		Average cache hit ratio for the object
SAMPLE_SIZE	NUMBER		The sample size used in analyzing this index
LAST_ANALYZED	DATE		The date of the most recent time this index was analyzed
GLOBAL_STATS	VARCHAR2	(3)	Are the statistics calculated without merging underlying partitions?
USER_STATS	VARCHAR2	(3)	Were the statistics entered directly by the user?
STATTYPE_LOCKED	VARCHAR2	(5)	type of statistics lock
STALE_STATS	VARCHAR2	(3)	Whether statistics for the object is stale or not
SCOPE	VARCHAR2	(7)	whether statistics for the object is shared or session

Query Text

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


SELECT OWNER
,      INDEX_NAME
,      TABLE_OWNER
,      TABLE_NAME
,      PARTITION_NAME
,      PARTITION_POSITION
,      SUBPARTITION_NAME
,      SUBPARTITION_POSITION
,      OBJECT_TYPE
,      BLEVEL
,      LEAF_BLOCKS
,      DISTINCT_KEYS
,      AVG_LEAF_BLOCKS_PER_KEY
,      AVG_DATA_BLOCKS_PER_KEY
,      CLUSTERING_FACTOR
,      NUM_ROWS
,      AVG_CACHED_BLOCKS
,      AVG_CACHE_HIT_RATIO
,      SAMPLE_SIZE
,      LAST_ANALYZED
,      GLOBAL_STATS
,      USER_STATS
,      STATTYPE_LOCKED
,      STALE_STATS
,      SCOPE
FROM SYS.DBA_IND_STATISTICS;

Dependencies

[top of page]

SYS.DBA_IND_STATISTICS references the following:

SYS: DBMS_STATS - show dependent code; DBMS_STATS_INTERNAL - show dependent code; IND$; INDCOMPARTV$; INDPARTV$; INDSUBPARTV$; IND_STATS$; MON_MODS_ALL$; OBJ$; PARTOBJ$; TAB$; TABCOMPARTV$; TABPARTV$; TABSUBPARTV$; USER$

SYS.DBA_IND_STATISTICS is referenced by following:

PUBLIC: DBA_IND_STATISTICS
SYS: PRVT_ADVISOR - show dependent code