Oracle Output Performance

[DMH1]

I am using Designer 2020.2.3 to read a read a 35M row SQL Server table and write it to an Oracle database.   The workflow takes about nine hours to run with most of the time spent writing rows in Oracle. 

On the SQL Server input side, my input tool executes a stored procedure that does all the heavy lifting and creates a temporary table that is picked up in the workflow.

On the Oracle output side, I don't seem to be able to specify many options.  Is there a way to specify things like "nologging" and "direct path insert" and other potential performance enhancements for the Oracle output?  

I ultimately want to move the workflow to our server gallery so I can schedule the process automatically.

Help!!

Thanks

Dave Harper (DMH1)

[BrandonB · Accepted solution]

@DMH1 have you configured the Oracle Output Data tool to leverage the bulk loader?

https://help.alteryx.com/current/designer/oracle

[DMH1]

Hi BrandonB,

I just set that up and will test it this evening.  Thank you so much for your response!  

Regards,

DMH1