ALL_TAB_HISTOGRAMS

ALL_TAB_HISTOGRAMS describes histograms on tables and views accessible to the current user.

Related Views

DBA_TAB_HISTOGRAMS describes histograms on all tables and views in the database.
USER_TAB_HISTOGRAMS describes histograms on all tables and views owned by the current user. This view does not display the OWNER column.

Note:

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

Column	Datatype	Description
`OWNER`	`VARCHAR2(30)`	Owner of the table
`TABLE_NAME`	`VARCHAR2(30)`	Name of the table
`COLUMN_NAME`	`VARCHAR2(4000)`	Column name or attribute of the object type column
`ENDPOINT_NUMBER`	`NUMBER`	Histogram bucket number
`ENDPOINT_VALUE`	`NUMBER`	Normalized endpoint value for this bucket
`ENDPOINT_ACTUAL_VALUE`	`VARCHAR2(1000)`	Actual (not normalized) string value of the endpoint for this bucket