Re: Reading and converting ALL_TAB_COL_STATISTICS
Date: Mon, 9 Nov 2009 15:27:58 +0100
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.
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....