Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_TAB_COL_STATISTICS

Columns of user's tables, views and clusters

Columns
   ___________________________
 
   USER_STATS
      Were the statistics entered directly by the user?
   COLUMN_NAME
      Column name
   NUM_DISTINCT
      The number of distinct values in the column
   LOW_VALUE
      The low value in the column
   HIGH_VALUE
      The high value in the column
   DENSITY
      The density of the column
   NUM_NULLS
      The number of nulls in the column
   GLOBAL_STATS
      Are the statistics calculated without merging underlying partitions?
   AVG_COL_LEN
      The average length of the column in bytes
   NUM_BUCKETS
      The number of buckets in histogram for the column
   TABLE_NAME
      Table, view or cluster name
   LAST_ANALYZED
      The date of the most recent time this column was analyzed
   SAMPLE_SIZE
      The sample size used in analyzing this column

Related Commands:

 DBA_PART_COL_STATISTICS  ALL_PART_COL_STATISTICS USER_PART_COL_STATISTICS 



Back to the Top

Simon Sheppard
SS64.com