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

VIEW: SYS.CDB_IND_STATISTICS

Object Details
Object Name: CDB_IND_STATISTICS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Optimizer statistics for all indexes in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30)
Username of the owner of the index
INDEX_NAME VARCHAR2 (30)
Name of the index
TABLE_OWNER VARCHAR2 (30)
Owner of the indexed object
TABLE_NAME VARCHAR2 (30)
Name of the indexed object
PARTITION_NAME VARCHAR2 (30)
Name of the partition
PARTITION_POSITION NUMBER

Position of the partition within index
SUBPARTITION_NAME VARCHAR2 (30)
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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_IND_STATISTICS;

Dependencies

[top of page]

SYS.CDB_IND_STATISTICS does not reference any database object

SYS.CDB_IND_STATISTICS is referenced by following:

SchemaPUBLIC
SynonymCDB_IND_STATISTICS