ALL_TAB_COL_STATISTICS displays column statistics and histogram information extracted from "ALL_TAB_COLUMNS".
DBA_TAB_COL_STATISTICS displays such information extracted from "DBA_TAB_COLUMNS".
USER_TAB_COL_STATISTICS displays such information extracted from "USER_TAB_COLUMNS". This view does not display the OWNER column.
Owner of the table
Name of the table
Number of distinct values in the column
Low value in the column
High value in the column
If a histogram is available on COLUMN_NAME, then this column displays the selectivity of a value that spans fewer than 2 endpoints in the histogram. It does not represent the selectivity of values that span 2 or more endpoints.
If a histogram is not available on COLUMN_NAME, then the value of this column is 1/NUM_DISTINCT.
Number of NULLs in the column
Number of buckets in histogram for the column
Date on which this column was most recently analyzed
Sample size used in analyzing this column
GLOBAL_STATS will be YES if statistics are gathered or incrementally maintained, otherwise it will be NO
Indicates whether statistics were entered directly by the user (YES) or not (NO)
Describes some additional properties of the statistics. For example, if the value is INCREMENTAL, the global statistics are derived from synopses, that is, the global statistics are incrementally maintained.
Average length of the column (in bytes)
Indicates existence/type of histogram:
The value is SHARED for statistics gathered on any table other than global temporary tables.
For a global tempoary table, the possible values are:
SESSION - Indicates that the statistics are session-specific
SHARED - Indicates that the statistics are shared across all sessions