Posted by Hennie7863 on 01/03/06 11:13

Hi,

For a customer we have implemented a datawarehouse with a connection to
Oracle. From the beginning of the project the connection to Oracle
gives troubles. The next morning is the connection still active and
when the customer looks in the processes of SQL Server a " Wait type,
RESOURCE_SEMAPHORE." is shown. For what i know. SQL Server is waiting
for a resource, in this case Oracle but doesn't tell me anything about
what could be the problem.

The customer uses the Oracle driver instead of a microsft oracle
driver.

What could it be? and how can we tackle this problem? Are there ways to
look from Oracle point of view? Can we monitor something?

Greetz,
Hennie

[Back to original message]