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

user5891944

From 10046 trace file , we found the time spent on PARSE !

Could anyone hit the same issue at 11.2.0.2 version ?

Please HELP ! HELP !

user5891944

congratulation! We have solved this issue ~~

user13257913

Hello sir,

I believe we may hit same issue.

Please, what was the solution for your team?

Many thanks.

catgib

Could you please share what the solution was for the slow inserts?

913477

Looking for a solution to SQL2008 Insert data to Oracle slow using OLEDB?