https://communities.sas.com/t5/SAS-Data-Management/Performance-tuning-DM-Server-and-Oracle/m-p/827983#M20520 <P>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.&nbsp;&nbsp;</P> Tue, 09 Aug 2022 20:34:18 GMT SASKiwi 2022-08-09T20:34:18Z https://communities.sas.com/t5/SAS-Data-Management/Performance-tuning-DM-Server-and-Oracle/m-p/827839#M20519 <P>Dear Team,</P> <P>&nbsp;</P> <P>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 ?</P> <P>&nbsp;</P> <P>I have attached one screenshot for your references. it may be taking long time to read the data from ORACLE db.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Shakti_Sourav_0-1660050407839.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/74281i5C4F7370275CD7F0/image-size/large?v=v2&amp;px=999" role="button" title="Shakti_Sourav_0-1660050407839.png" alt="Shakti_Sourav_0-1660050407839.png" /></span></P> <P>&nbsp;</P> <P>Let me know if required any further details</P> <P>&nbsp;</P> <P>Thank You</P> <P>Shakti</P> <P>&nbsp;</P> Tue, 16 Aug 2022 10:34:39 GMT https://communities.sas.com/t5/SAS-Data-Management/Performance-tuning-DM-Server-and-Oracle/m-p/827839#M20519 Shakti_Sourav 2022-08-16T10:34:39Z https://communities.sas.com/t5/SAS-Data-Management/Performance-tuning-DM-Server-and-Oracle/m-p/827983#M20520 <P>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.&nbsp;&nbsp;</P> Tue, 09 Aug 2022 20:34:18 GMT https://communities.sas.com/t5/SAS-Data-Management/Performance-tuning-DM-Server-and-Oracle/m-p/827983#M20520 SASKiwi 2022-08-09T20:34:18Z https://communities.sas.com/t5/SAS-Data-Management/Performance-tuning-DM-Server-and-Oracle/m-p/832413#M20550 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. Thu, 08 Sep 2022 21:02:29 GMT https://communities.sas.com/t5/SAS-Data-Management/Performance-tuning-DM-Server-and-Oracle/m-p/832413#M20550 VincentRejany 2022-09-08T21:02:29Z