RE: UL - contention Wait Event
- From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
- To: Joze.Senegacnik@xxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 11 Jun 2007 13:01:49 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Jože Senegacnik
Sent: Monday, June 11, 2007 12:40 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Dean Richards
Sent: 11. junij 2007 18:31
To: oracle-l@xxxxxxxxxxxxx
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.
------------------------------------------------------------------------------
NOTICE: This electronic mail message and any attached files are confidential.
The information is exclusively for the use of the individual or entity intended
as the recipient. If you are not the intended recipient, any use, copying,
printing, reviewing, retention, disclosure, distribution or forwarding of the
message or any attached file is not authorized and is strictly prohibited. If
you have received this electronic mail message in error, please advise the
sender by reply electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your computer
system. Thank you.
==============================================================================
Other related posts:
