ALL_TAB_HISTOGRAMS

ALL_TAB_HISTOGRAMS describes histograms on tables and views accessible to the 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 called statistics on the index using the ANALYZE statement or the DBMS_STATS package.

  Column	Datatype	NULL	Description
  OWNER	VARCHAR2(30)		Owner of 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