Re: Locking Problem

Setting a correct value for initrans is important.

When initrans space is not available it is the only time Oracle locks at block level as oppose to row level. This can cause transactions which use no keys in common with another transaction to lock out each other.

The default value for initrans is one so only enough space if reserved for a single user. More space will be used but only if it is available. If it's not you will lock the block. This can lead to deadlocks.

Shad wrote:

> 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 Wed Mar 03 1999 - 03:58:08 CST