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:
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.