frontend application sometimes gets locked / backend is Oracle 8i

From: Bernd Rosenau <brosenau_at_gss-online.de>
Date: Fri, 13 Oct 2000 10:00:44 +0100
Message-ID: <7ljduso9ajbjfkb6k0fe1sragnmrnr00b0@4ax.com>

Hello,

our app is programmed in VB 6.0. It connects to Oracle 8i by ADO.

It sometimes happens that the frontend software gets into a "locked" state. This happens to all frontend clients (approx. 20)

It makes me think there is somewhere a lock on database tables leading to this problem.

On which tables can i look into to see what happens ?

How can i avoid such a situation ?
In some parts, quite long transactions are used, can they lead to such a deadlock situation ?

Many thanks in advance for your help,

Regards, Bernd Received on Fri Oct 13 2000 - 04:00:44 CDT