SQL> select * from dba_tab_col_statistics where table_name='KC22';
OWNER TABLE_NAME COLUMN_NAME NUM_DISTINCT LOW_VALUE HIGH_VALUE DENSITY NUM_NULLS NUM_BUCKETS LAST_ANALY SAMPLE_SIZE GLO USE AVG_COL_LEN
------------------------------ ------------------------------ ------------------------------ ------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------- ---------- ----------- ---------- ----------- --- --- -----------
HIS_TRANS KC22 AKB020 1 313030303034 313030303034 .006666667 0 1 2006/09/25 403976 NO NO 6
HIS_TRANS KC22 AAC001 3201 30303030313639303633 31303030343434323436 .001748913 0 75 2006/09/25 403976 NO NO 10
HIS_TRANS KC22 AKC190 4187 3039303732393139 5942393031353436313230303630393136 .001333772 0 75 2006/09/25 403976 NO NO 17
HIS_TRANS KC22 CKC131 5556 3230303431303230313633353430323230 3230303630393235313533363332323533 .000179986 34375 1 2006/09/25 403976 NO NO 16
HIS_TRANS KC22 CKC133 394811 3C2D3D6066 3C630B1866 2.5329E-06 0 1 2006/09/25 403976 NO NO 5
HIS_TRANS KC22 AKC220 17005 303930373239313931 CDCB3939 .001890984 0 75 2006/09/25 403976 NO NO 3
HIS_TRANS KC22 BKC220 932 20 393938 .001072961 0 1 2006/09/25 403976 NO NO 2
HIS_TRANS KC22 AKC515 2244 30313031303031435030 5A5A464C4C2E30303935 .004356004 0 64 2006/09/25 403976 NO NO 10
HIS_TRANS KC22 AKC516 2462 302E30323525B5CFCEACCBAA28CEAC41CBE1292AA1F7A1F7 F7C6B9C7B9C7D5DBC7D0BFAAB8B4CEBBC4DAB9CCB6A8CAF5 .000406174 0 1 2006/09/25 403976 NO NO 19
HIS_TRANS KC22 CKC130 2 2D31 31 1.2377E-06 0 1 2006/09/25 403976 NO NO 2
HIS_TRANS KC22 AAE072 5408 3039303732393139 41414141 .001238086 0 69 2006/09/25 403976 NO NO 8
OWNER TABLE_NAME COLUMN_NAME NUM_DISTINCT LOW_VALUE HIGH_VALUE DENSITY NUM_NULLS NUM_BUCKETS LAST_ANALY SAMPLE_SIZE GLO USE AVG_COL_LEN
------------------------------ ------------------------------ ------------------------------ ------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------- ---------- ----------- ---------- ----------- --- --- -----------
HIS_TRANS KC22 AKC221 413 78680809010101 786A0919010101 .002421308 0 1 2006/09/25 403976 NO NO 7
HIS_TRANS KC22 AKA063 15 30 3934 .066666667 0 1 2006/09/25 403976 NO NO 2
HIS_TRANS KC22 AKC222 2020 30303030303031 5A313030383032 .00049505 22753 1 2006/09/25 403976 NO NO 9
HIS_TRANS KC22 AKC223 1762 22D6ACB7BEC8E9 F7C6B9C7B9C7D5DBC7D0BFAAB8B4CEBBC4DAB9CCB6A8CAF5 .000567537 22798 1 2006/09/25 403976 NO NO 15
HIS_TRANS KC22 AKC224 3 31 33 .333333333 0 1 2006/09/25 403976 NO NO 1
HIS_TRANS KC22 AKA065 4 30 33 .25 0 1 2006/09/25 403976 NO NO 1
HIS_TRANS KC22 AKC225 1802 C002 C3095D33 .000554939 0 1 2006/09/25 403976 NO NO 3
HIS_TRANS KC22 AKC226 743 3D5F5766 C20A .001345895 0 1 2006/09/25 403976 NO NO 3
HIS_TRANS KC22 AKC227 3984 3C63580466 C3095D33 .000251004 0 1 2006/09/25 403976 NO NO 3
HIS_TRANS KC22 AKC228 1809 3D473866 C3024F33 .000552792 634 1 2006/09/25 403976 NO NO 2
HIS_TRANS KC22 AKC253 1532 3C64120566 C3025461 .000652742 350738 1 2006/09/25 403976 NO NO 2
OWNER TABLE_NAME COLUMN_NAME NUM_DISTINCT LOW_VALUE HIGH_VALUE DENSITY NUM_NULLS NUM_BUCKETS LAST_ANALY SAMPLE_SIZE GLO USE AVG_COL_LEN
------------------------------ ------------------------------ ------------------------------ ------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------- ---------- ----------- ---------- ----------- --- --- -----------
HIS_TRANS KC22 AAE073 0 2.4754E-06 403976 1 2006/09/25 NO NO 1
HIS_TRANS KC22 CKA002 1 30 30 1 373339 1 2006/09/25 403976 NO NO 1
HIS_TRANS KC22 AKA070 0 2.4754E-06 403976 1 2006/09/25 NO NO 1
HIS_TRANS KC22 AKA071 0 2.4754E-06 403976 1 2006/09/25 NO NO 1
HIS_TRANS KC22 AKA072 0 2.4754E-06 403976 1 2006/09/25 NO NO 1
HIS_TRANS KC22 AKA073 0 2.4754E-06 403976 1 2006/09/25 NO NO 1
HIS_TRANS KC22 CKC111 123 31323630 74303232 .008130081 0 1 2006/09/25 403976 NO NO 6
HIS_TRANS KC22 AKC229 1 80 80 1 0 1 2006/09/25 403976 NO NO 1
HIS_TRANS KC22 CKC048 0 2.4754E-06 403976 1 2006/09/25 NO NO 1
HIS_TRANS KC22 ZKA020 0 2.4754E-06 403976 1 2006/09/25 NO NO 1
HIS_TRANS KC22 CKC125 2 3E6466 C102 .5 0 1 2006/09/25 403976 NO NO 3
OWNER TABLE_NAME COLUMN_NAME NUM_DISTINCT LOW_VALUE HIGH_VALUE DENSITY NUM_NULLS NUM_BUCKETS LAST_ANALY SAMPLE_SIZE GLO USE AVG_COL_LEN
------------------------------ ------------------------------ ------------------------------ ------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------- ---------- ----------- ---------- ----------- --- --- -----------
HIS_TRANS KC22 CKC127 0 2.4754E-06 403976 1 2006/09/25 NO NO 1
HIS_TRANS KC22 CKC126 2 80 C102 .5 0 1 2006/09/25 403976 NO NO 2
HIS_TRANS KC22 CDC100 0 2.4754E-06 403976 1 2006/09/25 NO NO 1
HIS_TRANS KC22 BAE101 2 80 C102 .5 126 1 2006/09/25 403976 NO NO 2
HIS_TRANS KC22 AKC265 0 2.4754E-06 403976 1 2006/09/25 NO NO 1
HIS_TRANS KC22 ZKC040 0 2.4754E-06 403976 1 2006/09/25 NO NO 1
HIS_TRANS KC22 AAE040 0 2.4754E-06 403976 1 2006/09/25 NO NO 1
HIS_TRANS KC22 BAE030 0 2.4754E-06 403976 1 2006/09/25 NO NO 1
HIS_TRANS KC22 BAE031 0 2.4754E-06 403976 1 2006/09/25 NO NO 1
HIS_TRANS KC22 AAE011 0 2.4754E-06 403976 1 2006/09/25 NO NO 1
HIS_TRANS KC22 AAE036 0 2.4754E-06 403976 1 2006/09/25 NO NO 1