Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Bulk loading partitioned tables slower than heap tables?
Hi
I was wondering if anyone has experience bulk loading data to partitioned tables? I have run some tests and running bulk load (insert append) into partitioned tables is actually 40% more costy. For example to load up a 80 million rows table it takes around 8 minutes whereas with plain heap table it only takes 5
Test used:
LMT with 16MB uniform size extent
No ASSM
Parallel DML
Parallel Query
Degree 16
Regards
Alex
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 23 2006 - 06:00:57 CDT
![]() |
![]() |