DataStage Job Long Running on DS 753 and DataBase Oracle 10g

Nareshkurra · Post by **Nareshkurra** » Thu Dec 31, 2009 1:51 am

Hi,

We are facing perfomrance issue when we are trying to run one of the DS job which contains many oracle stages as lookup's.When contacted DBA he confirmed that there is only one connection from DataStage and it is trying to fetch the data from all the oracle stages.

Where as the same job in our old server(DS 751,Oracle 9i) is initiating many DataBase Connections and the job is running well in time

Can anybody suggest what can be done to resolve this.

chulett · Post by **chulett** » Thu Dec 31, 2009 7:23 am

I don't really see how one versus many connections running the same set of SQL would really make a difference. Have you checked that your explain plans in 10g are still appropriate, what you saw in 9i?