Re: enq: UL - contention Wait Event

  • From: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
  • To: snowman327@xxxxxxxxx
  • Date: Mon, 11 Jun 2007 10:43:59 -0700

Dean,

UL- User Supplied Lock. Check the SQL causing the wait.

-Gopal


On 6/11/07, Dean Richards <snowman327@xxxxxxxxx> wrote:



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.








--
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/
--
//www.freelists.org/webpage/oracle-l


Other related posts: