I have few questions on the table partitioning. Someone created a table which has 7 hash partition, but I noticed that the partition 4 is higher than the rest. What is the reason for this ?
Anyone have ideas on add hash subpartition in the hash table ?
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?