Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_SUBPART_HISTOGRAMS

ALL_SUBPART_HISTOGRAMS lists the actual histogram data (end-points per histogram) for histograms on table subpartitions accessible to the current user.

Related Views

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 name
TABLE_NAME VARCHAR2(30)
Table name
SUBPARTITION_NAME VARCHAR2(30)
Table subpartition name
COLUMN_NAME VARCHAR2(30)
Column name
BUCKET_NUMBER NUMBER
Bucket number
ENDPOINT_VALUE NUMBER
Normalized endpoint values for this bucket
ENDPOINT_ACTUAL_VALUE VARCHAR2(1000)
Actual (not normalized) string value of the endpoint for this bucket