How to know the locked rows of a table ?

From: Mathieu KREMBEL <m.krembel_at_wanadoo.fr>
Date: 2000/02/29
Message-ID: <89hfqv$r86$2@wanadoo.fr>#1/1

Hi,

I need to know the locked rows of a table. In our intranet application, we use only one oracle user account. There are several sessions of the same user. The rows of a table can be locked with a "select... for update nowait" query. When the application fails, we have to delete the locks.

The v$session view gives us the sid and the serial no, the sys.v$locked_object the object_id of the locked tables.

But is it possible to get the rowid of the rows locked in the object_id tables ?

Thanks for your answers,

---

Matthieu KREMBEL
E-Mail : m.krembel_at_wanadoo.fr Received on Tue Feb 29 2000 - 00:00:00 CST