Checking collation compatibility helped little. But it still took 32 seconds to transfer 2590 records from SQL Server.

I am not sure, what I am missing here.

I have a problem with linked server slowness.

I am trying to insert data from SQL server to Oracle in a Sql server stored procedure. It is working ok, with out...