Re: exploring histogram of a varchar2 column

http://mwidlake.wordpress.com/2009/08/11/decrypting-histogram-data/

On Sun, Dec 7, 2014 at 12:06 AM, oracledba <oracledba71_at_gmail.com> wrote:

> Hi,
>
> I am trying to understand how Oracle stores varchar2 data type columns in
> histograms and why it ignores the characters after 6 or 7 characters.
>
> colname ENDPOINT_NUMBER HEX_VALUE CHAR_VALUE
> ENDPOINT_VALUE ENDPOINT_ACTUAL_VALUE
> ------- --------------- ------------------------------ ---------------
> ------------------------------------------------
> ----------------------------------------
> V10 0 4170706c650002c34b2e037ea00000 Apple
> 339,779,832,781,057,000,000,000,000,000,000,000 Apple
>
>
> Converting ENDPOINT_NUMBER HEX VALUE 4170706c650002c34b2e037ea00000 to
> decimal and exclude evrytthing after first 15 digits, then Oracle
> stores 3.3977983278106E+35.
>
> In the Hex value 4170706c650002c34b2e037ea00000, I could understand
> 41 - A 70 - p 70 - p 6c - l 65 - e what 0002c34b2e037ea00000 are? how
> they are calculated?
>
> Thanks
> Antony
>
>

-- 
Best regards,
Sayan Malakshinov
Senior performance tuning engineer
PSBank
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l