link server from Oracle to SQL server occurs blocking on SQL server

Hi,

Our problem is:

Select query sent from Oracle link to SQL server is blocking other processes accessing tempdb on SQL server. (This link was created on Oracle server side.) The following is an example select query: select * from g_valudaily_at_INV_DEV2_FMC

What we can do for now is if the problem occurs we kill that process on the SQL server side.

We have already opened case to Microsoft support and we didn't get satisfied answer right now. Do you have some ideas?

Thanks for your help!

Susan

-- 
Posted from fire-dmz.otpp.com [207.245.246.34] 
via Mailgate.ORG Server - http://www.Mailgate.ORG