3.136 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(128)

Owner of the table or index for which the statistics have been collected

OBJECT_NAME

VARCHAR2(128)

Name of the table or index for which the statistics have been collected

PARTITION_NAME

VARCHAR2(128)

Partition name of a table; NULL if the table is either nonpartitioned 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(128)

Column name, if OBJECT_TYPE is COLUMN, for which statistics have been collected

STATSTYPE_SCHEMA

VARCHAR2(128)

Schema of the statistics type which was used to collect the statistics

STATSTYPE_NAME

VARCHAR2(128)

Name of the statistics type which was used to collect statistics

STATISTICS

RAW(2000)

User-collected statistics for the object

See Also: