Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: endpoint_value and endpoint_actual_value

Re: endpoint_value and endpoint_actual_value

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 23 Mar 2006 11:39:19 -0800
Message-ID: <bf46380603231139o10f7f87fyd5dacc0e43c0c7da@mail.gmail.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US