[Home] [Help] [Dependency Information]
Object Name: | ALL_USTATS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All statistics
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) | Name of the partition (if applicable) for which the stats have been collected | |
OBJECT_TYPE | VARCHAR2 | (6) | Type of the object - Column or Index | |
ASSOCIATION | VARCHAR2 | (8) | If the statistics type association is direct or implicit | |
COLUMN_NAME | VARCHAR2 | (128) | Column name, if property is column for which statistics have been collected | |
STATSTYPE_SCHEMA | VARCHAR2 | (128) | Schema of statistics type which was used to collect the statistics | |
STATSTYPE_NAME | VARCHAR2 | (128) | Name of statistics type which was used to collect statistics | |
STATISTICS | RAW | (2000) | User collected statistics for the object |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_OWNER
, OBJECT_NAME
, PARTITION_NAME
, OBJECT_TYPE
, ASSOCIATION
, COLUMN_NAME
, STATSTYPE_SCHEMA
, STATSTYPE_NAME
, STATISTICS
FROM SYS.ALL_USTATS;
|
|
|