Rows Per Partition Skewed in Hash Partitioned Table (Doc ID 1068430.1)

Last updated on JUNE 10, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.

Symptoms

A hash-partitioned table has 5 hash partitions, which are partitioned on a numeric column.  When 850 rows are inserted, the counts per partition appear skewed. 
The rows are distributed as follows: 
SQL> select count(*) from IDORRCC.PRUEBA_NACIMIENTOS partition(P1); 
 COUNT(*) 
---------- 
        0 
SQL> select count(*) from IDORRCC.PRUEBA_NACIMIENTOS partition(P2); 
 COUNT(*) 
---------- 
        0 
SQL> select count(*) from IDORRCC.PRUEBA_NACIMIENTOS partition(P3); 
 COUNT(*) 
---------- 
      500 
SQL> select count(*) from IDORRCC.PRUEBA_NACIMIENTOS partition(P4); 
 COUNT(*) 
---------- 
      250 
SQL> select count(*) from IDORRCC.PRUEBA_NACIMIENTOS partition(P5); 
 COUNT(*) 
---------- 
      100

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms