Page 1 of 1
GETTING BETTER PERFORMANCE FOR ORACLE LOAD
Posted: Mon Apr 09, 2007 6:15 am
by dsisbank
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.
Posted: Mon Apr 09, 2007 6:18 am
by chulett
"Didn't work" how? If you do a straight command line sqlldr direct path load from this file, how long does it take?
Posted: Mon Apr 09, 2007 7:50 am
by kcbland
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.
Posted: Mon Apr 09, 2007 8:23 am
by chulett
Ken is challenging your "it's very bad performance" statement. I would have gotten there.
Posted: Mon Apr 09, 2007 2:55 pm
by ray.wurlod
Any reason not to use PARALLEL=TRUE in your control file?
Posted: Mon Apr 09, 2007 3:19 pm
by jatayl
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....