Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to know the locked rows of a table ?

Re: How to know the locked rows of a table ?

From: Tom Zamani <tomz_at_redflex.com.au>
Date: 2000/03/01
Message-ID: <89i60n$io9$1@perki.connect.com.au>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US