Object lock identification

From: Kenneth A Kauffman <kkauffman_at_nospam.headfog.com>
Date: Wed, 02 Jul 2003 15:54:20 GMT
Message-ID: <MeDMa.32$ZT5.7@news2.east.cox.net>

In a nutshell, I have object locking occurring from what appears to be a bad application design and would like to identify specific values that are trying to be inserted.

By doing the following:

select * from v$lock;
SELECT object_name FROM dba_objects WHERE object_id=<objectID(s)_from_above_query>;

I can identify the rowids/blocks of the table objects that are locking. However, in the .trc file I see the reference to the objects:

Session 79: obj - rowid = 00006102 - AAAAAAAAIAAAbrMAAA
(dictionary objn - 24834, file - 8, block - 113356, slot - 0)
Session 81: obj - rowid = 00006102 - AAAAAAAAIAAAbrMAAA
(dictionary objn - 24834, file - 8, block - 113356, slot - 0)

What I would like to know is how do I identify the values that are trying to be inserted/deleted into the common row? ... or is this possible?

ken k Received on Wed Jul 02 2003 - 10:54:20 CDT