DBA_USTATS

DBA_USTATS describes the user-defined statistics collected on all tables and indexes in the database. Its columns are the same as those in ALL_USTATS.

Related Views

· ALL_USTATS describes the user-defined statistics collected on the tables and indexes accessible to the current user.

· USER_USTATS describes the user-defined statistics collected on the tables and indexes owned by the current user.

Column	Datatype	NULL	Description
OBJECT_OWNER	VARCHAR2(30)		Owner of the table or index for which the statistics have been collected
OBJECT_NAME	VARCHAR2(30)		Name of the table or index for which the statistics have been collected
PARTITION_NAME	VARCHAR2(30)		Partition name of a table; NULL if the table is either non-partitioned or the entry corresponds to the aggregate statistics for the table
OBJECT_TYPE	VARCHAR2(6)		Type of the object for which statistics have been collected: · INDEX · COLUMN
ASSOCIATION	VARCHAR2(8)		Statistics type association: · DIRECT Direct association with the object for which the statistics have been collected · IMPLICIT - Association for which the statistics have been collected is with the column type or index type, and the object is an instance of that column type or index type
COLUMN_NAME	VARCHAR2(30)		Column name, if OBJECT_TYPE is COLUMN, for which statistics have been collected
STATSTYPE_SCHEMA	VARCHAR2(30)		Schema of the statistics type which was used to collect the statistics
STATSTYPE_NAME	VARCHAR2(30)		Name of the statistics type which was used to collect statistics
STATISTICS	RAW(2000)		User-collected statistics for the object

Note:

1.

select * from DBA_USTATS;

OBJECT_ OWNER	OBJECT_NAME	PARTITION_ NAME	OBJECT_ TYPE	ASSOCIATION	COLUMN_ NAME	STATSTYPE_ SCHEMA	STATSTYPE_ NAME	STATISTICS
USERA	LAKE_POLY_ST		COLUMN	IMPLICIT	SHAPE	SDE	ST_DOMAIN_STATS	53484150453A30
USERA	A808_IX1		INDEX	IMPLICIT		SDE	ST_DOMAIN_STATS	413830388313A3

Oracle data dictionary views

Oracle dynamic performance views