DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

user5891944Dec 30 2010 — edited Jan 26 2012

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 23 2012

Added on Dec 30 2010

#oracle-provider-for-ole-db, #windows-and-net

5 comments

367 views