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
Last activity: Sep 20, 2024, 09:06 PM