Hi Gurus
We are trying to use linked server to oracle.
A simple insert of 100 rows is taking 3 minutes,
If i do bcp out and sql loader in to oracle it is just few seconds.
Is there away to find out what is wrong.
How can i use trace, or profiler to check what is happning on the oracle
end.
we are pushing data from SQL to Oracle

Lots of people have this problem and the problem is usually related to the
driver and network protocols.

I found this discussion which may help

http://www.experts-exchange.com/Data..._21202938.html

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Nik" <sqlserverkb (AT) yahoo (DOT) com> wrote