[VIEW] DBA_TAB_STATISTICS

DBA_TAB_STATISTICS 란?

데이터베이스에 있는 모든 테이블들에 대한 옵티마이저 통계를 표시

 

Description

 

Column	Type	Null	Description
OWNER	VARCHAR2(128)	NO	The owner of the object.
TABLE_NAME	VARCHAR2(128)	NO	The name of the table.
PARTITION_NAME	VARCHAR2(128)	NO	The name of the partition.
PARTITION_POSITION	NUMBER	NO	The position of the partition within the table.
SUBPARTITION_NAME	VARCHAR2(128)	NO	The name of the subpartition.
SUBPARTITION_POSITION	NUMBER	NO	The position of the subpartition in the partition.
OBJECT_TYPE	VARCHAR2(12)	NO	The type of the object. TABLE PARTITION SUBPARTITION
NUM_ROWS	NUMBER	NO	The number of rows in the object.
BLOCKS	NUMBER	NO	The value is NULL.
EMPTY_BLOCKS	NUMBER	NO	The value is NULL.
AVG_SPACE	NUMBER	NO	The value is NULL.
CHAIN_CNT	NUMBER	NO	The value is NULL.
AVG_ROW_LEN	NUMBER	NO	The average row length of the object.
AVG_SPACE_FREELIST_BLOCKS	NUMBER	NO	The value is NULL.
NUM_FREELIST_BLOCKS	NUMBER	NO	The value is NULL.
AVG_CACHED_BLOCKS	NUMBER	NO	The value is NULL.
AVG_CACHE_HIT_RATIO	NUMBER	NO	The value is NULL.
IM_IMCU_COUNT	NUMBER	NO	The value is NULL.
IM_BLOCK_COUNT	NUMBER	NO	The value is NULL.
IM_STAT_UPDATE_TIME	TIMESTAMP(9)	NO	The value is NULL.
SCAN_RATE	NUMBER	NO	The value is NULL.
SAMPLE_SIZE	NUMBER	NO	The sample size when statistics are collected.
LAST_ANALYZED	DATE	NO	The date when the column was analyzed the last time.
GLOBAL_STATS	VARCHAR2(3)	NO	YES: indicates that the statistics are directly collected or incrementally maintained. NO: other cases.
USER_STATS	VARCHAR2(3)	NO	Indicates whether the partition statistics are set by the user.
STATTYPE_LOCKED	VARCHAR2(5)	NO	The statistics lock type. DATA CACHE ALL : 통계 정보 생성 불가 옵션 (ORA-20005 에러 발생)
STALE_STATS	VARCHAR2(3)	NO	Indicates whether the statistics are stale.
SCOPE	VARCHAR2(7)	NO	The effective scope of the statistics.