Hello
I have a question. When i am loading Oracle table from datastage, the load was very slow. In what way i can increase the load speed. Please mention all the possible ways to increase the load speed. Currenltly the load was very slow. It was around 700 records per second. Please reply
Oracle table load
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
Yes the table is partitioned.keshav0307 wrote:Sarath
it depends on your requirement.
you should give full details about your current design and your requirements.
what type of load is used? i guess it is upsert.
is the table partitioned ?
Can i use the ORABULK stage. What are the constraints i have if i use orabulk stage.
Its just load. Nothing to worry about the business requirements.
Currenlty i am using upsert. But if possibe with orabulk i can only use insert statements
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
Re: Oracle table load
Hi,just4u_sharath wrote:Hello
Please mention all the possible ways to increase the load speed (for Oracle load).
For fact load
========
1) If it is an append of records, load into a temporary table . then exchange this temp table into the daily partition.
2) go for bulk/direct path load.
3)Run the load stand-alone (As in 2). Collect statistics
4)Tune 3 until satisfied
5) Simulate the process from DS.
6)collect system statistics. if needed add more h/w
hope this helps!
regards,
Prabu