DBA_TAB_HISTOGRAMS

DBA_TAB_HISTOGRAMS describes histograms on columns of all tables in the database. Its columns are the same as those in "ALL_TAB_HISTOGRAMS".

Related Views

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

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

Note:

1.

select * from DBA_TAB_HISTOGRAMS where table_name = 'SDE_LOGPOOL_968';

OWNER	TABLE_NAME	COLUMN_NAME	ENDPOINT_NUMBER	ENDPOINT_VALUE	ENDPOINT_ACTUAL_VALUE
SDE	SDE_LOGPOOL_968	LOGFILE_DATA_ID	6817	2147483639
SDE	SDE_LOGPOOL_968	SDE_ROW_ID	0	100
SDE	SDE_LOGPOOL_968	SDE_ROW_ID	1	145747

Oracle data dictionary views

Oracle dynamic performance views