select substrb(dump(val,16,0,32),1,120) ep, cnt
from
(select /*+ no_parallel(t) no_parallel_index(t) 
dbms_stats cursor_sharing_exact 
use_weak_name_resl dynamic_sampling(0) 
no_monitoring */
max(substrb("COL1",1,32)) val,count(*) cnt
from "OWNER1"."TAB1" t
where substrb("COL1",1,32) is not null 
group by nlssort(substrb("COL11",1,32), 'NLS_SORT = binary')) 
order by nlssort(val,'NLS_SORT = binary');

select substrb(dump(val,16,0,32),1,120) ep, cnt
from
(select /*+ no_parallel(t) no_parallel_index(t) dbms_stats 
cursor_sharing_exact use_weak_name_resl 
dynamic_sampling(0) no_monitoring */
max("C") val,count(*) cnt
from "USER"."T" t
where "C" is not null group by nlssort("C", 'NLS_SORT = binary')) 
order by nlssort(val,'NLS_SORT = binary');

select  min(minbkt),maxbkt,
substrb(dump(min(val),16,0,32),1,120) minval,
substrb(dump(max(val),16,0,32),1,120) maxval,
sum(rep) sumrep, sum(repsq) sumrepsq, 
max(rep) maxrep, count(*) bktndv, 
sum(case when rep=1 then 1 else 0 end) unqrep
from
(select val,min(bkt) minbkt, max(bkt) maxbkt, 
count(val) rep, count(val)*count(val) repsq
from
(select /*+ no_parallel(t) no_parallel_index(t) 
dbms_stats cursor_sharing_exact use_weak_name_resl 
dynamic_sampling(0) no_monitoring */
"C" val, ntile(254) 
over (order by nlssort("C",'NLS_SORT = binary')) bkt
from "USER"."T" t
where TBL$OR$IDX$PART$NUM("USER"."T",0,4,0,"ROWID") 
= :objn and "C" is not null) 
group by val) 
group by maxbkt 
order by maxbkt