Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Bulk loading partitioned tables slower than heap tables?

Bulk loading partitioned tables slower than heap tables?

From: amonte <ax.mount_at_gmail.com>
Date: Fri, 23 Jun 2006 13:00:57 +0200
Message-ID: <85c1fb130606230400l763e0815ga2735aca613ae2aa@mail.gmail.com>


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-l
Received on Fri Jun 23 2006 - 06:00:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US