【脚本】显示Oracle12c中4种histogram的数据分布情况

我花了2天的时间，把以前的脚本更新了，现在可以显示4种histogram的列数据分布情况了

  HISTOGRAM         EPV(EndPointValue) EP_ROWS     EP% Density%
--------------- -------------------------------- ------------ ------- --------
FREQUENCY    2                     100     9.76    1.6667
FREQUENCY    3                     500    48.78    1.6667
FREQUENCY    4                     3     .29    1.6667
FREQUENCY    5                     10     .98    1.6667
FREQUENCY    6                     5     .49    1.6667
FREQUENCY    7                     407    39.71    1.6667
                             -------
sum                             100.00


HISTOGRAM         EPV(EndPointValue) EP_ROWS     EP% Density%
--------------- -------------------------------- ------------ ------- --------
TOP-FREQUENCY    2                     100    16.00    2.0000
TOP-FREQUENCY    3                     500    80.00    2.0000
TOP-FREQUENCY    5                     10     1.60    2.0000
TOP-FREQUENCY    6                     5     .80    2.0000
TOP-FREQUENCY    7                     7     1.12    2.0000
                             -------
sum                                99.52



HISTOGRAM         EPV(EndPointValue) EP_ROWS     EP% Density%
--------------- -------------------------------- ------------ ------- --------
HEIGHT BALANCED 1                     7     .45     .4464
HEIGHT BALANCED 2                     300    20.00     .4464
HEIGHT BALANCED 5.3                     7     .45     .4464
HEIGHT BALANCED 6.1                     7     .45     .4464
HEIGHT BALANCED 10                     450    30.00     .4464
HEIGHT BALANCED 11                     7     .45     .4464
HEIGHT BALANCED 13                     7     .45     .4464
HEIGHT BALANCED 200                     7     .45     .4464
                             -------
sum                                52.68



HISTOGRAM         EPV(EndPointValue) EP_ROWS     EP% Density%
--------------- -------------------------------- ------------ ------- --------
HYBRID        1                     20     1.33     .4583
HYBRID        2                     310    20.67     .4583
HYBRID        5.3                     103     6.87     .4583
HYBRID        6.1                     120     8.00     .4583
HYBRID        9.6                     100     6.67     .4583
HYBRID        10                     420    28.00     .4583
HYBRID        13                     130     8.67     .4583
HYBRID        195                     1     .07     .4583
HYBRID        198                     1     .07     .4583
HYBRID        200                     1     .07     .4583
                             -------
sum                                80.40

除了支持新的两种histogram外增加了2点功能：
1 因为NewDensity无法从直接查询出来，我把它显示出来为Density，对于Frequency histogram是没用的
2 Density和EP%,谁大优化器用谁(Frequency除外)
3 对EP%做了一个summary, 大概能显示popular value占的总比重

脚本在这里下载：
show_histogram_12c.sql