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	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