Re: Reading and converting ALL_TAB_COL_STATISTICS

have you checked Martin Widlake's blog, especially this entry: http://mwidlake.wordpress.com/2009/09/03/decrypting-histogram-data-2/

maybe this is a good starting-point.

hth,
Martin

On Mon, Nov 9, 2009 at 15:22, Martin Klier <Martin.Klier_at_klug-is.de> wrote:
>
> Dear list,
>
> how can I convert the raw(32)  columns LOW_VALUE and HIGH_VALUE of
> ALL_TAB_COL_STATISTICS to their decimal value? TO_NUMBER(rawtohex
> (high_value),'XXXXXXXX') gives me not the value I expect (stats are recent)
> and in the table min(id) is 1 and max(id) is 8 million). DUMPing the values
> (see last part of the SQL below) does not give me any better idea....

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