[Home] [Help]
VIEW: SYS.INDEX_HISTOGRAM
Source
View Text - Preformatted
select hist.indx * power(2, stats.kdxstscl-4) repeat_count,
hist.kdxhsval keys_with_repeat_count
from x$kdxst stats, x$kdxhs hist
View Text - HTML Formatted
SELECT HIST.INDX * POWER(2
, STATS.KDXSTSCL-4) REPEAT_COUNT
,
HIST.KDXHSVAL KEYS_WITH_REPEAT_COUNT
FROM X$KDXST STATS
, X$KDXHS HIST