DSXchange

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.

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?