Re: DBA_LOCK fields

From: Kristiaan J. Kolk <akolk_at_ix.netcom.com>
Date: 1998/03/19
Message-ID: <351155EE.834AFC89@ix.netcom.com>#1/1

No,

The lock_id1 and lock_id2 have different logical meanings depending on the lock type. for example if lock type is TM, id1 is the object id. If type is TX, id1 means the rbs nr & slot nr, id2 is the wrap number.

So as you can see it all depends !

Anjo.

I work for Oracle, but I speak for myself.

Dalibor Kovac wrote:

> Can anybody tell me what do the fields
> LOCK_ID1
> LOCK_ID2
> in the DBA_LOCK view contain?
> I know that one of those IDs is an object_id of a locked object,
> but what's the other one?
>
> Thanks,
>
> Dalibor Kovac
> dalibor_kovac_at_yahoo.com
Received on Thu Mar 19 1998 - 00:00:00 CST