DBA_TAB_HISTOGRAMS

This view describes histograms on all the tables and views generated when collecting statistics using the ANALYZE statement or DBMS_STATS package. There are the equivalent views ALL_TAB_HISTOGRAMS and USER_TAB_HISTOGRAMS; the first contains information on all the objects accessible by the current user, the last on the current user objects in the database.

Fields

The most relevant view fields are as follows:

  • OWNER: The owner of the table
  • TABLE_NAME: The name of the table
  • COLUMN_NAME: The name of the column
  • ENDPOINT_NUMBER: The histogram bucket number
  • ENDPOINT_VALUE: The normalized endpoint value for the bucket
  • ENDPOINT_ACTUAL_VALUE: The actual endpoint value (not normalized) for the bucket

Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial