Finding information about object for LOCK TYPE = UL

From: New DBA <new_dba_on_the_block_at_yahoo.com>
Date: Tue, 15 Feb 2005 05:21:18 -0800 (PST)
Message-ID: <20050215132119.39182.qmail@web53303.mail.yahoo.com>

Hi,

After tracing a slow running transaction, I noticed that most of the time was spent waiting on enqueue. After drilling down further I saw the following line multiple times in the trace files.

WAIT #169: nam='enqueue' ela= 3021648 p1=1431044102 p2=1073754670 p3=0

So from P1 I can make out that the LOCK TYPE is 'UL' and requested mode is 6 (Exclusive). So I query DBMS_LOCK_ALLOCATED matching p2 with LOCKID.

So far so good. Since I have little information about user lock through DBMS_LOCK I'm stuck.

I see name = 'ORA$DR_DML_ 02954: 000' in the DBMS_LOCK_ALLOCATED for LOCKID = 1073754670 (p2 from the trace file).

Now my question is how to find the object for which the lock was requested from this information. Which table or view can help me in finding this information.

Oracle Apps 11.5.8 DB 9.2.0.5

Regards
New DBA

Do you Yahoo!?
Yahoo! Mail - now with 250MB free storage. Learn more. http://info.mail.yahoo.com/mail_250

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 15 2005 - 08:24:08 CST