ALL_SUBPART_HISTOGRAMS

ALL_SUBPART_HISTOGRAMS lists the actual histogram data (end-points per histogram) for histograms on table subpartitions accessible to the current user.

Related Views

• DBA_SUBPART_HISTOGRAMS provides this information for all subpartitions in the database.
• USER_SUBPART_HISTOGRAMS provides this information for subpartitions of all partitioned objects owned by the current user. This view does not display the OWNER column.

  Note: These views are populated only if you called statistics on the index using the ANALYZE statement or the DBMS_STATS package.

  Column	Datatype	NULL	Description
  OWNER	VARCHAR2(30)		Owner name
  TABLE_NAME	VARCHAR2(30)		Table name
  SUBPARTITION_NAME	VARCHAR2(30)		Table subpartition name
  COLUMN_NAME	VARCHAR2(30)		Column name
  BUCKET_NUMBER	NUMBER		Bucket number
  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