Forum Stats

  • 3,817,472 Users
  • 2,259,339 Discussions
  • 7,893,790 Comments

Discussions

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

user5891944
user5891944 Member Posts: 3
edited Jan 26, 2012 1:42PM in Oracle Provider for OLE DB
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

Answers

This discussion has been closed.