SSX lock

From: Stephan Bressler <stephan.bressler_at_pdb.sbs.de>
Date: Tue, 15 Jan 2002 14:04:13 +0100
Message-ID: <a219bv$q61$1@news.mch.sbs.de>

Hi,

I've got a locking problem on 8.1.7.

v$locks shows 1 session holding a lock (type 5) on table a while some other sessions are requesting locks(type 3) on table a.

What causes type 5 (SSX) locks (beside 'lock table in share row exclusiv mode' statements)?

Some describe problems with missing foreign key indexes. But my experiments show locks type 4 (shared table lock) on the child tables.

TIA
Stephan Received on Tue Jan 15 2002 - 07:04:13 CST