Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: link server from Oracle to SQL server occurs blocking on SQL server
On Wed, 21 Nov 2001 17:08:29 +0000 (UTC), "Susan Yunew"
<susan_yu_at_otpp.com> wrote:
>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
Definitely looks like a Microsoft problem. I don't think this is the correct forum to help in resolving Microsoft problems
Regards
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Wed Nov 21 2001 - 12:28:19 CST