How to know the rows locked in a table ?
From: Mathieu KREMBEL <m.krembel_at_wanadoo.fr>
Date: 2000/02/29
Message-ID: <89hfvf$4sr$1_at_wanadoo.fr>#1/1
Matthieu KREMBEL
E-Mail : m.krembel_at_wanadoo.fr Received on Tue Feb 29 2000 - 00:00:00 CET
Date: 2000/02/29
Message-ID: <89hfvf$4sr$1_at_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 CET