Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Where is histogram information stored?

April 26, 2017histogram stored

0

Posted

Where is histogram information stored?

1 Answer

0

Posted

Histogram information is stored in objects of the Oracle data dictionaries in the SYSTEM tablespace in exactly the same way as information about normal statistics. You can access this information using DBA_TAB_HISTOGRAMS (tables) and DBA_PART_HISTOGRAMS (partitions). For each histogram bucket, there is an entry in the DBA view. The ENDPOINT_NUMBER column references the relevant bucket. For volume-based histograms, there is also another entry that defines the starting point for the first bucket. The actual data is contained in the HIST_HEAD$ and HISTGRM$ tables, in which HISTGRM$ is contained in the C_OBJ#_INTCOL# Oracle cluster.