Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_USTATS

All statistics collected on either tables or indexes

Columns
   ___________________________
 
   COLUMN_NAME
      Column name, if property is column for which statistics have been collected
   ASSOCIATION
      If the statistics type association is direct or implicit
   STATISTICS
      User collected statistics for the object
   STATSTYPE_NAME
      Name of statistics type which was used to collect statistics
   OBJECT_OWNER
      Owner of the table or index for which the statistics have been collected
   OBJECT_TYPE
      Type of the object - Column or Index
   OBJECT_NAME
      Name of the table or index for which the statistics have been collected
   STATSTYPE_SCHEMA
      Schema of statistics type which was used to collect the statistics 

Related Commands:




Back to the Top

Simon Sheppard
SS64.com