DBA_IND_STATISTICS
DBA_IND_STATISTICSの仕様
索引のオプティマイザ統計情報
名前 NULL? 型
----------------------------------------------------- -------- ------------------------------------
OWNER VARCHAR2(30)
INDEX_NAME VARCHAR2(30)
TABLE_OWNER VARCHAR2(30)
TABLE_NAME VARCHAR2(30)
PARTITION_NAME VARCHAR2(30)
PARTITION_POSITION NUMBER
SUBPARTITION_NAME VARCHAR2(30)
SUBPARTITION_POSITION NUMBER
OBJECT_TYPE VARCHAR2(12)
BLEVEL NUMBER
LEAF_BLOCKS NUMBER
DISTINCT_KEYS NUMBER
AVG_LEAF_BLOCKS_PER_KEY NUMBER
AVG_DATA_BLOCKS_PER_KEY NUMBER
CLUSTERING_FACTOR NUMBER
NUM_ROWS NUMBER
AVG_CACHED_BLOCKS NUMBER
AVG_CACHE_HIT_RATIO NUMBER
SAMPLE_SIZE NUMBER
LAST_ANALYZED DATE
GLOBAL_STATS VARCHAR2(3)
USER_STATS VARCHAR2(3)
STATTYPE_LOCKED VARCHAR2(5)
STALE_STATS VARCHAR2(3)
page revision: 3, last edited: 18 Nov 2009 13:56