Purpose
The USER_PART_HISTOGRAMS view displays the histograms of the partitions of the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
ALL_PART_HISTOGRAMSDBA_PART_HISTOGRAMS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table where the histogram belongs. |
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the partition where the histogram belongs. |
| COLUMN_NAME | VARCHAR2(128) | NO | The name of the column where the histogram belongs. |
| ENDPOINT_NUMBER | NUMBER | NO | The number of bucket accumulations. |
| ENDPOINT_VALUE | NUMBER | NO | The normalized endpoint value of the bucket. |
| ENDPOINT_ACTUAL_VALUE | VARCHAR2(4000) | NO | The endpoint value of the bucket. |
| ENDPOINT_ACTUAL_VALUE_RAW | VARCHAR2(4000) | NO | The binary endpoint value of the bucket. |
| ENDPOINT_REPEAT_COUNT | NUMBER | NO | The number of times that the endpoint value of the bucket appears. |