Locking Problem

From: Shad <aaa_at_bbb.com>
Date: Tue, 2 Mar 1999 09:53:18 -0800
Message-ID: <7bgceh$aef@romeo.logica.co.uk>

Hi,
I've got a strange problem with table locking in Oracle 7.3.4 running on AIX 4.

We've got a large(ish) batch job which runs doing a number of transactions on a number of tables which locks the affected rows in the tables. The problem is that it often seems to completely lock other users out of the tables so that they can't do any work on other customers/accounts which are nothing to do with the batch job being executed.

Can anyone suggest what might be causing this problem, what might be done about it, or even which views/tables might give more information about where the problem lock is.

Thanks for your help. Received on Tue Mar 02 1999 - 11:53:18 CST