Re: endpoint_value and endpoint_actual_value

  • From: "Charles Schultz" <sacrophyte@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 4 Aug 2006 12:41:40 -0500

I would like to revisit this thread briefly. I believe Jerry was referring
back to Lex's response:

He also mentioned hexstr from AskTom:,F4950_P8_CRITERIA:707586567563

Woflgang speculated that Oracle only encodes the first 6 characters, and
will populate actual_value for character fields "when it needs to".

Given all this, it seems that there is no way to reverse-engineer a bucket
on a character column consistently. Is that still true in 10gR2? In my own
testing, this seems to be the case, especially if the column is larger than
6 characters. Even when it is not (when the column is less than 6
characters), the "encoding" process still makes decoding rather difficult. I
used the hexstr function but it is too easy to get control characters in the
stream (even using substr).

Is there any other way to analyze the bucket information for histograms on
character fields?

Charles Schultz

Other related posts: