SQL> select sum(bytes)/1024/1024/1024,segment_name,PARTITION_NAME from user_segments
2 where PARTITION_NAME like 'HU1306%' or PARTITION_NAME like 'REN1306%'
3 group by segment_name,PARTITION_NAME order by 2,3;
除了分区HU130602已经压缩,其他分区的压缩都比较大
0.005065918 HU HU130602 0.004882813 HU1 HU130602 0.963855514
0.004882813 HU HU130603 0.002929688 HU1 HU130603 0.600000041
0.00390625 HU HU130604 0.002929688 HU1 HU130604 0.750000128
0.006835938 HU HU130621 0.004882813 HU1 HU130621 0.714285735
0.009765625 HU HU130622 0.006835938 HU1 HU130622 0.700000051
0.005859375 HU HU130623 0.00390625 HU1 HU130623 0.666666667
0.00390625 HU HU130624 0.002929688 HU1 HU130624 0.750000128
0.008789063 HU HU130625 0.006835938 HU1 HU130625 0.77777779
0.0078125 HU HU130626 0.005859375 HU1 HU130626 0.75
0.0078125 HU HU130627 0.005859375 HU1 HU130627 0.75
0.004882813 HU HU130628 0.00390625 HU1 HU130628 0.799999918
0.00390625 HU HU130629 0.002929688 HU1 HU130629 0.750000128
0.004882813 HU HU130630 0.00390625 HU1 HU130630 0.799999918
0.00390625 HU HU130631 0.002929688 HU1 HU130631 0.750000128
0.006835938 HU HU130632 0.004882813 HU1 HU130632 0.714285735
0.008789063 HU HU130633 0.006835938 HU1 HU130633 0.77777779
0.0078125 HU HU130634 0.005859375 HU1 HU130634 0.75
0.006835938 HU HU130635 0.004882813 HU1 HU130635 0.714285735
0.004882813 HU HU130636 0.00390625 HU1 HU130636 0.799999918
0.00390625 HU HU130637 0.002929688 HU1 HU130637 0.750000128
0.004882813 HU HU130638 0.00390625 HU1 HU130638 0.799999918
0.008789063 HU HU130681 0.006835938 HU1 HU130681 0.77777779
0.015625 HU HU130682 0.01171875 HU1 HU130682 0.75
0.005859375 HU HU130683 0.004882813 HU1 HU130683 0.833333419
0.0078125 HU HU130684 0.005859375 HU1 HU130684 0.75