ALL_SUBPART_HISTOGRAMS
displays the actual histogram data (end-points per histogram) for histograms on table subpartitions accessible to the current user.
Related Views
DBA_SUBPART_HISTOGRAMS
displays this information for all subpartitions in the database.
USER_SUBPART_HISTOGRAMS
displays this information for subpartitions of all partitioned objects 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 of the table |
|
|
|
Name of the table |
|
|
|
Table subpartition name |
|
|
|
Column name |
|
|
|
Bucket number |
|
|
|
Normalized endpoint values for this bucket |
|
|
|
Actual (not normalized) string value of the endpoint for this bucket |
|
|
|
Endpoint actual value in raw format |
|
|
|
Frequency of the endpoint (applies only to hybrid histograms, and is set to 0 for other histogram types) |
See Also:
Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_STATS
package