Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_USTATS

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

Related Views

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