Oracle table load

[just4u_sharath]

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

[keshav0307]

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 ?

[just4u_sharath]

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 ?

Yes the table is 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

[keshav0307]

do you limitations of the UPSERT and Bulk Load.
Bulk load is used for only insert but you have to also consider the index.
Indexes play important role in both.

read the parallel job developers guide guide chapter 13

[prabu]

Hello
Please mention all the possible ways to increase the load speed (for Oracle load).

Hi,


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