This discussion is archived
5 Replies Latest reply: Jan 26, 2012 10:42 AM by 913477 RSS

After upgrade to 11.2.0.2 , SQL2008 Insert data to Oracle slow using OLEDB

user5891944 Newbie
Currently Being Moderated
Hi All,

If any body hit the same issue as the following case ?

We have a job in SQL2008 Insert data to Oracle 11g using OLEDB Linked Server.

Previously in 9.2.0.8 & 11.2.0.1 version , the insert speed is very fast .

But after we upgrade oracle to 11.2.0.2 , the insert speed drop down a lot , maybe 1min to 10min .....

Could any body give any idea ?

Best Regards
ChiaChan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points