1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES
  4. ALL_PART_HISTOGRAMS

3.2 ALL_PART_HISTOGRAMS

ALL_PART_HISTOGRAMS displays the histogram data (endpoints per histogram) for the histograms on the table partitions accessible to the current user.

Related Views

  • DBA_PART_HISTOGRAMS displays the histogram data for the histograms on all table partitions in the database.

  • USER_PART_HISTOGRAMS displays the histogram data for the histograms on the table partitions 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 DBMS_STATS package.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

Owner of the table

TABLE_NAME

VARCHAR2(128)

Name of the table

PARTITION_NAME

VARCHAR2(128)

Name of the table partition

COLUMN_NAME

VARCHAR2(4000)

Name of the column

BUCKET_NUMBER

NUMBER

Bucket number of the histogram

ENDPOINT_VALUE

NUMBER

Normalized endpoint values for the bucket

ENDPOINT_ACTUAL_VALUE

VARCHAR2(4000)

Actual (not normalized) string value of the endpoint for the bucket

ENDPOINT_ACTUAL_VALUE_RAW

RAW(1000)

Endpoint actual value in raw format

ENDPOINT_REPEAT_COUNT

NUMBER

Frequency of the endpoint (applies only to hybrid histograms, and is set to 0 for other histogram types)

See Also: