topic Re: Oracle input query time in Talend Studio

Oracle input query time

seaferring — Sat, 16 Nov 2024 04:30:18 GMT

Why would a query that takes 140 seconds in Oracle SQL Developer take 348 seconds in a Talend job?

Is there something else going on here beside a raw query? Pics included...

Re: Oracle input query time

Anonymous — Tue, 01 Oct 2019 22:08:49 GMT

Hi,

Could you please increase the memory parameters of the Talend job as the first step? The data coming from Oracle need to be gathered in the memory of Talend job. If the amount of memory allocation is less, the job processing might become slower.

I would also recommend to verify the explain plans for both case from Oracle DB with the help of DBAs. If the explain generated is different in both cases, the job execution plan may vary.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Oracle input query time

seaferring — Fri, 01 Nov 2019 18:14:35 GMT

I solved the problem. It was a network issue and not Talend.

Thank you.