Sample Header Ad - 728x90

Turn on multi-threading in Oracle for ETL purposes

0 votes
1 answer
1181 views
As you can see from this question, I was able to configure multi-threading in SQL Server and build a workflow in Informatica to multi-thread a job to move data faster into SQL Server. https://dba.stackexchange.com/questions/107966/multi-thread-informatica-connections-to-use-different-processors-on-target-datab Now I'd like to do the same thing in Oracle. Does anyone know the feature in Oracle that's comparable to the "Max Degree of Parallelism" setting in SQL Server? I'd like to move data on each core of the server in parallel. I'm strictly dealing with INSERT statements. So DML.
Asked by JustBeingHelpful (2116 rep)
Jan 11, 2016, 06:46 PM
Last activity: Sep 20, 2024, 09:06 PM