You might like to get the Jonathan Lewis book on the CBO and
carefully go over the chapter on histograms. He explains it rather well.
http://www.amazon.com/gp/product/1590596366
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On 3/16/06, Jerry Brenner <jbrenner_at_guidewire.com> wrote:
>
> We have a tool in our product that displays the database statistics for
> all of the tables in the schema in order to help with remote debugging of
> performance problems. Right now, we simply list out the contents of a
> histogram in an html table, but we are trying to get to the point of
> including a graphical representation of the histograms that includes the end
> point values. I'm trying to figure out how to properly decode the values in
> endpoint_value. Here's what I've come up with so far:
>
>
>
> SELECT h.table_name, h.column_name, data_type, histogram, endpoint_number,
> endpoint_value, endpoint_actual_value,
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 23 2006 - 13:39:19 CST
