Feature
USER_PART_HISTOGRAMS lists 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 MySQL mode.
Related views
ALL_PART_HISTOGRAMS
DBA_PART_HISTOGRAMS
Fields
| Field | 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. |