ALL_USTATS
describes all user-defined statistics accessible to the current user.
DBA_USTATS
describes all user-defined statistics in the database.
USER_USTATS
describes all user-defined statistics 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 | |
OBJECT_TYPE |
VARCHAR2(6) |
Indicates the type of object for which statistics have been collected: COLUMN or INDEX |
|
ASSOCIATION |
VARCHAR2(8) |
DIRECT Indicates a direct association with the object for which the statistics have been collected.
|
|
COLUMN_NAME |
VARCHAR2(30) |
Column name, if property is column for which statistics have been collected | |
STATSTYPE_SCHEMA |
VARCHAR2(30) |
Schema of statistics type which was used to collect the statistics | |
STATSTYPE_NAME |
VARCHAR2(30) |
Name of statistics type which was used to collect statistics | |
STATISTICS |
RAW(2000) |
User collected statistics for the object | |
PARTITION_NAME |
VARCHAR2(30) |
Partition name of a table. If null, the table is either non-partitioned or the entry corresponds to the aggregate statistics for the table. |