Table Partitioning
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Table Partitioning

  1. #1
    Join Date
    Oct 2000
    Posts
    250

    Table Partitioning

    Hi All,
    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 ?

    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Hash partitions are not guaranteed to be evenly distributed.

    See Oracle Docs for details on how to add a partition.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Also, if you use hash partitioning, the number of partitions should be in power of 2. So it woul dbe wise to have 8 partitions instead of 7 as you have now.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    It indicates that the column chosen for hash partition is not the right choice.

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width