Re: enq: UL - contention Wait Event

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Mon, 11 Jun 2007 10:43:59 -0700
Message-ID: <3b0f44a10706111043m1b2a600dybb37c00da7bc8191@mail.gmail.com>

Dean,

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

-Gopal

On 6/11/07, Dean Richards <snowman327_at_gmail.com> 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/
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 11 2007 - 12:43:59 CDT