ALL_PART_COL_STATISTICS

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

Related Views

• DBA_PART_COL_STATISTICS provides such information for all table partitions in the database.
• USER_PART_COL_STATISTICS provides such information for all partitions of tables 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(30)	NOT NULL	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 this column
  LAST_ANALYZED	DATE		Date on which this 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)		Whether the statistics were entered directly by the user
  AVG_COL_LEN	NUMBER		Average length of the column, in bytes