Originally posted by tamilselvan
It indicates that the column chosen for hash partition is not the right choice.
Much more likely it is the consequence of the fact that the number of partitions is not being a power of two. Any other number of hash partitions leads to unbalanced partitioning. It's because Oracle internal hash partitioning alghoritm revolves around powers of two. The whole concept is perfectly and in details explained in Jothan Lewis's book "Practical Oracle8i". Here is a strong recomendation from that chapter:
"To ensure uniform data distribution across hash partitions you should always specify the number of partitions to be a power of two (2, 4, 8, 16, 32, asn so on). If you do not do this, some partitions are twice the size of other partitions."
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?