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.

Why is ENDPOINT_ACTUAL_VALUE in DBA_TAB_HISTOGRAMS partially unfilled?

April 26, 2017unfilled

0

Posted

Why is ENDPOINT_ACTUAL_VALUE in DBA_TAB_HISTOGRAMS partially unfilled?

1 Answer

0

Posted

The ENDPOINT_ACTUAL_VALUE contains the endpoints of individual histogram buckets in readable form. Therefore, it is suitable for analyses of optimizer decisions in connection with histograms. However, this column is not always filled. DBMS_STATS statistics in particular do not often fill this column. This is not a matter of a bug, but rather the normal behavior (compare information from Oracle bug 3333781), since ENDPOINT_ACTUAL_VALUE is only intended for Oracle-internal purposes.