Row Locking on Oracle 8

From: Juan Carlos Alonso Lafuente <jcalonso_at_wke.es>
Date: Fri, 17 Sep 1999 18:48:00 +0200
Message-ID: <37E270BF.BB401F59@wke.es>

We are developing using Oracle 8 on the NT platform and we would like to know how to deal with locks in some specific ways.

In particular, we are using "SELECT ... FOR UPDATE" to lock a row when one user wants to access that particular row.

The question is that we would like to know who is blocking one row in a table and which particular row (its rowid).

Using v$session and v$lock we get to know who is blocking a particular object (a table) but we do not know the row being blocked.

If anyone could help us on this it would be greatly appreciated. Carlos Alonso
La Ley - Actualidad, Legal Publishers.
Madrid, Spain Received on Fri Sep 17 1999 - 11:48:00 CDT