ALL_USTATS

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

Related Views

  • DBA_USTATS describes the user-defined statistics collected on all tables and indexes in the database.

  • 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

See Also: