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
      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