Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
seaferring
Contributor
Contributor
‎2019-10-01 04:10 PM

Oracle input query time

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...

Labels (3)
Labels
297 Views
0 Likes
2 Replies
Anonymous
Not applicable
‎2019-10-01 06:08 PM

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

297 Views
0 Likes
seaferring
Contributor
Contributor
‎2019-11-01 02:14 PM
Author

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

 

Thank you.

297 Views
0 Likes