JavaScript must be enabled to correctly display this content

ALL_TAB_COL_STATISTICS

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.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`		Owner of the table
`TABLE_NAME`	`VARCHAR2(128)`		Name of the table
`COLUMN_NAME`	`VARCHAR2(128)`		Column name
`NUM_DISTINCT`	`NUMBER`		Number of distinct values in the column
`LOW_VALUE`	`RAW(1000)`		Low value in the column
`HIGH_VALUE`	`RAW(1000)`		High value in the column
`DENSITY`	`NUMBER`		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`.
`NUM_NULLS`	`NUMBER`		Number of NULLs in the column
`NUM_BUCKETS`	`NUMBER`		Number of buckets in histogram for the column
`LAST_ANALYZED`	`DATE`		Date on which this column was most recently analyzed
`SAMPLE_SIZE`	`NUMBER`		Sample size used in analyzing this column
`GLOBAL_STATS`	`VARCHAR2(3)`		`GLOBAL_STATS` will be `YES` if statistics are gathered or incrementally maintained, otherwise it will be `NO`
`USER_STATS`	`VARCHAR2(3)`		Indicates whether statistics were entered directly by the user (`YES`) or not (`NO`)
`NOTES`	`VARCHAR2(99)`		Describes some additional properties of the statistics. For example: A value of `INCREMENTAL` indicates that the global statistics are derived from synopses, that is, the global statistics are incrementally maintained. A value of `STATS_ON_CONVENTIONAL_LOAD` indicates that the statistics are obtained by online statistics gathering for conventional DML.
`AVG_COL_LEN`	`NUMBER`		Average length of the column (in bytes)
`HISTOGRAM`	`VARCHAR2(15)`		Indicates existence/type of histogram: `NONE` `FREQUENCY` `HEIGHT BALANCED` `HYBRID` `TOP-FREQUENCY`
`SCOPE`	`VARCHAR2(7)`		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 See Oracle AI Database PL/SQL Packages and Types Reference for information about using the `GLOBAL_TEMP_TABLE_STATS` preference of the `DBMS_STATS` package to control whether to gather session or shared statistics for global temporary tables.

See Also: