Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

client wants me to speed up the sqlldr load, 1 million per second, Is this possible?

ivwviMar 3 2014 — edited Mar 8 2014

Dear Experts,

I have 700G file to load using sqlldr on windows server 2012 (oracle installed is 11gR2).

I have 40GB RAM

SGA 15GB

I need to fasten the sqlldr load.

ctl file i am using is

OPTIONS(DIRECT=TRUE, ROWS=1000000, SKIP=1, ERRORS=1000000)

unrecoverable

load data

infile 'D:\3_PV_TD2.txt'

append into table c_3_PV_TD2

fields terminated by '|' optionally enclosed by '"'

(

ACCURACY_LINE_ITEM_FLAG,

PRICE_NEGOTIATED,

CURRENCY_CODE,

CONTRACT_NUMBER,

CONTRACT_TYPE,

COVERAGE,

COVERED_ITEM,

COVERED_LINE_CURRENCY_CODE,

COVERED_LINE_END_DATE Date "YYYY/MM/DD HH24:MI:SS"

)

Currently its 1 million records in 2 minutes.

Question : how to speed up the sqlldr? Can I use parallel option without splitting the input txt file?

Thanks & Regards

This post has been answered by BrunoVroman on Mar 3 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 5 2014

Added on Mar 3 2014

#database-key-features, #export-import-sql-loader-external-tables

14 comments

5,059 views