Performance tuning: DM Server and Oracle

[Shakti_Sourav]

Dear Team,

I have created a batch data job which is taking 10 hours to read having 3 crores of Rows. Please suggest how to improve the performance in SAS Data Management Server ?

I have attached one screenshot for your references. it may be taking long time to read the data from ORACLE db.

Let me know if required any further details

Thank You

Shakti

[SASKiwi]

Have you tried running just reading of Oracle part? I suggest you make a copy of your job and delete all except the first four tasks - up to Data Union 1. Then test how long that takes. Your job will not be any faster than how long it takes to read your data.  

[VincentRejany]

Agree with SASKiwi. If the Union can be done in Oracle that would be better. Next you can fine tune the parameters I mentioned in another post in the cluster node.