Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: link server from Oracle to SQL server occurs blocking on SQL server

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

From: Sybrand Bakker <oradba_at_sybrandb.demon.nl>
Date: Wed, 21 Nov 2001 19:28:19 +0100
Message-ID: <2gsnvtsgcbspef3lp6q711bep5qs4jpohe@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US