SSIS performance vs OpenQuery with Linked Server from SQL Server to Oracle
There is probably some buffer/flag somewhere that allows to achieve the same?
Probably looking for the FetchSize parameter
FetchSize - specifies the number of rows the provider will fetch at a time (fetch array). It must be set on the basis of data size and the response time of the network. If the value is set too high, then this could result in more wait time during the execution of the query. If the value is set too low, then this could result in many more round trips to the database. Valid values are 1 to 429,496, and 296. The default is 100.
eg
exec sp_addlinkedserver N'MyOracle', 'Oracle', 'ORAOLEDB.Oracle', N'//172.16.8.119/xe', N'FetchSize=2000', ''
I think there are many way to enhance the performance on the INSERT query, I suggest reading the following article to get more information about data loading performance.
There are one method you can try which is minimizing the logging by using clustered index. check the link below for more information: