SELECT
A.XIDUSN , A.XIDSLOT , A.XIDSQN , A.OBJECT_ID , A.SESSION_ID
, A.ORACLE_USERNAME , A.OS_USER_NAME , A.PROCESS , A.LOCKED_MODE
FROM
SYS.V_$LOCKED_OBJECT A
Mathieu KREMBEL <m.krembel_at_wanadoo.fr> wrote in message
news:89hfqv$r86$2_at_wanadoo.fr...
> 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 Wed Mar 01 2000 - 00:00:00 CST
