How to Display HIGH_VALUE/LOW_VALUE Columns from USER_TAB_COL_STATISTICS

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

https://github.com/grahn/oracle_scripts/blob/master/display_raw.sql

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

9 comments

  1. Pingback: dbms_stats.copy_table_stats does not alter low/high value « AskDba.org 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

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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