ALL_PART_COL_STATISTICS

ALL_PART_COL_STATISTICS displays column statistics and histogram information for the table partitions accessible to the current user.

Related Views

DBA_PART_COL_STATISTICS displays column statistics and histogram information for all table partitions in the database.
USER_PART_COL_STATISTICS displays column statistics and histogram information for the table partitions owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the partitioned table
`TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the table
`PARTITION_NAME`	`VARCHAR2(30)`		Name of the table partition
`COLUMN_NAME`	`VARCHAR2(4000)`		Name of the column
`NUM_DISTINCT`	`NUMBER`		Number of distinct values in the column
`LOW_VALUE`	`RAW(32)`		Low value in the column
`HIGH_VALUE`	`RAW(32)`		High value in the column
`DENSITY`	`NUMBER`		Density of the column
`NUM_NULLS`	`NUMBER`		Number of nulls in the column
`NUM_BUCKETS`	`NUMBER`		Number of buckets in histogram for the column
`SAMPLE_SIZE`	`NUMBER`		Sample size used in analyzing the column
`LAST_ANALYZED`	`DATE`		Date on which the column was most recently analyzed
`GLOBAL_STATS`	`VARCHAR2(3)`		Indicates whether column statistics were collected for the partition as a whole (`YES`) or were estimated from statistics on underlying subpartitions (`NO`)
`USER_STATS`	`VARCHAR2(3)`		Indicates whether statistics were entered directly by the user (`YES`) or not (`NO`)
`AVG_COL_LEN`	`NUMBER`		Average length of the column (in bytes)
`HISTOGRAM`	`VARCHAR2(15)`		Indicates existence/type of histogram: `NONE` `FREQUENCY` `HEIGHT BALANCED`