ALL_PART_HISTOGRAMS

ALL_PART_HISTOGRAMS provides the histogram data (endpoints per histogram) for histograms on table partitions accessible to the current user.

Related views:

• DBA_PART_HISTOGRAMS provides such information for all table partitions in the database.

• USER_PART_HISTOGRAMS 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)		Owner of the table
  TABLE_NAME	VARCHAR2(30)		Name of the table
  PARTITION_NAME	VARCHAR2(30)		Name of the table partition
  COLUMN_NAME	VARCHAR2(30)		Name of the column
  BUCKET_NUMBER	NUMBER		Bucket number of the histogram
  ENDPOINT_VALUE	NUMBER		Normalized endpoint values for this bucket
  ENDPOINT_ACTUAL_VALUE	VARCHAR2(1000)		Actual (not normalized) string value of the endpoint for this bucket.