Here is some code to display the HIGH_VALUE/LOW_VALUE columns from USER_TAB_COL_STATISTICS which are stored as RAW datatypes.

COLUMN_NAME          LOW_VAL          HIGH_VAL         DATA_TYPE
-------------------- ---------------- ---------------- ---------
ORGANIZATION_ID      00D000000000062  00D300000000tgk  CHAR
UG_ID                00500000000008U  00GD0000000mBda  CHAR
USERS_ID             005000000000063  00G30000000mBcq  CHAR
IS_TRANSITIVE        0                1                CHAR
SUPPRESS_RULES       0                1                CHAR


  1. Pingback: dbms_stats.copy_table_stats does not alter low/high value « Weblog
  2. Pingback: Plan stability through Upgrade to 11G- Building a test case « Coskan’s Approach to Oracle
  3. Pingback: Implicit Datatype Conversion + Histograms = Bad Execution Plan? | Structured Data
  4. zhwsh

    >elsif (type = ‘ROWID’) then
    > dbms_stats.convert_raw_value(rawval, cr);
    > return to_char(cnv);
    modify :

    elsif (type = ‘ROWID’) then
    dbms_stats.convert_raw_value(rawval, cr);
    return to_char(cr);

  5. Pingback: Copy_table_stats « OraStory
  6. jeff humphreys

    Note that this won’t work if you are unable to create this as proc on the source, so not useful for ETLs – unless an anonymous block would work.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s