GETTING BETTER PERFORMANCE FOR ORACLE LOAD

dsisbank · Post by **dsisbank** » Mon Apr 09, 2007 6:15 am

I have 17 million rows data in txt file.I use oracle stage for load medhod.This takes about 1 hour.It's very bad performance.How can i speed up?

when is use $APT_ORACLE_LOAD OPTIONS with OPTIONS(DIRECT=TRUE,UNRECOVERABLE),ıt didnt work.

chulett · Post by **chulett** » Mon Apr 09, 2007 6:18 am

"Didn't work" how? If you do a straight command line sqlldr direct path load from this file, how long does it take?

kcbland · Post by **kcbland** » Mon Apr 09, 2007 7:50 am

What's running on the database server at the same time? Were the cpus and disks busy before you started your load? What about the target table? Was it empty? Is it partitioned? Is it indexed? Are they locally managed or global? What about triggers and constraints? What does a row of data look like? Is it a bunch of ints and decimals, or lots of text? Is it 10 columns or 1000 columns?

How about a little more information.

chulett · Post by **chulett** » Mon Apr 09, 2007 8:23 am

Ken is challenging your "it's very bad performance" statement. I would have gotten there.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 09, 2007 2:55 pm

Any reason not to use PARALLEL=TRUE in your control file?

jatayl · Post by **jatayl** » Mon Apr 09, 2007 3:19 pm

What version of Oracle are you on? 9.2.05, I believe, has a bug that causes DataStage loads to take forever....I believe it had something to do with querying DBA Extents, or something like that....