Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

RE: UL - contention Wait Event

Joze Senegacnik

2007-06-11

Replies:

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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Dean Richards
Sent: 11. junij 2007 18:31
To: oracle-l@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.

 

 

 

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.