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.
GETTING BETTER PERFORMANCE FOR ORACLE LOAD
Moderators: chulett, rschirm, roy
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.
How about a little more information.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: