Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: UL - contention Wait Event
Are your programmers using a 'select .. for update', then waiting on user input? That would easily cause that problem.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jože Senegacnik
Sent: Monday, June 11, 2007 12:40 PM
To: oracle-l_at_freelists.org
Subject: RE: UL - contention Wait Event
UL stands for 'User-defined Lock'. Obviously some of your sessions are waiting because of user locks. See DBMS_LOCK package.
Regards, Joze
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dean Richards
Sent: 11. junij 2007 18:31
To: oracle-l_at_freelists.org
Subject: enq: UL - contention Wait Event
Does anyone know what the wait event named "enq: UL - contention" means? There is nothing in Metalink or anywhere that I can find that gives the definition. I have a session that waits more than 90% of its time on this event.
Thanks.
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 11 2007 - 13:01:49 CDT
![]() |
![]() |