Re: locking problems lock_id1 utllockt

From: Rolf Hauck <Rolf.Hauck_at_datenrevision.de>
Date: Fri, 28 Aug 1998 07:45:35 +0200
Message-ID: <35E643FF.21EA8D12@datenrevision.de>

Hi, Ron,
I don't know anything about utllockt. When we have locking problems, I do the following:

1. determine the locking process: select SID from v$lock where block=1
2. locked objects: select object_id from v$locked_object
3. description of locked objects: select * from all_objects where

object_id = THE_ID_FROM_STEP2

Is this what you are interested in?
Sorry, I can't help with row locks.

Rolf

Ronald wrote:
>
> Hi,
>
> oracle 7.3.4.2 on aix 4.1.5

[SNIP]
>
> What I am wondering now is: how do I find out what db object is involved in a
> lock ? utllockt.sql gives a list containing LOCK_ID1 and LOCK_ID2. How can I
> use these to get the table/row of whatever that it is that's locked. I think
> it's a pointer to some temporary structure.
>
Received on Fri Aug 28 1998 - 00:45:35 CDT