Finding information about object for LOCK TYPE = UL
- From: New DBA <new_dba_on_the_block@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 15 Feb 2005 05:21:18 -0800 (PST)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
