Re: v$lock columns, info about rollback slot??

From: Manuela Mueller <520040906697-0001_at_t-online.de>
Date: Wed, 19 Dec 2001 15:21:15 +0100
Message-ID: <3C20A25B.90CB453B@t-online.de>

Hello Stephan,
thanks a lot for your reply, was very helpful. I set up another test situation: the user locked his table and made updates out of PL/SQL loop with commit and sleep() to slow things artificially down. In the meantime user sys run the query on v$lock. output:
USERNA SID SERIAL# ID1 ID2 LMODE TY CTIME
------ ---------- ---------- ---------- ---------- ---------- --

---

ADDR KADDR
-------- --------
MANU 9 63 2960 0 5 TM 13 <--TM, before commit
51DC7E5C 51DC7E70  

MANU            9         63     131104       1232          6
TX          0 <--TX, update is committed!
0958692C 095869F8                                                 

Regards
Manuela Mueller

Stephan Bressler wrote:
>
> Hi Manuela,
>
> I believe the update was not issued yet (for there is no TX lock entry). The
> addr and kaddr columns represent memory addressses, no idea how to resolve
> them.
> The ID columns represent a reference into rollback in case of TX lock only.
> In case of a TM lock they reference dba_objects.objekt_id.
>
> Regards
> Stephan
Received on Wed Dec 19 2001 - 08:21:15 CST