Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: row level (transactional) locking problem

Re: row level (transactional) locking problem

From: Boris Dali <boris_dali_at_yahoo.ca>
Date: Mon, 9 Feb 2004 15:09:23 -0500 (EST)
Message-ID: <20040209200923.35933.qmail@web41413.mail.yahoo.com>


One follow-up question, Jonathan.

If not IOTs, nor bitmap indexes - what could be the other reasons for mode=4 lock requests from the blocked sessions trying to do an update (I know for inserts it can be things like pk constraint enforcement, but I can't think of any reason other than ITL shortage if the sql waiting/blocked is an update)?

Here's an example from utllockt output (165 blocks say 441 requesting lock mode=4):

WAIT_SES LTYPE REQUEST HELD LOCK_ID1 LOCK_ID2 -------- ----- ------- ----- -------- -------- ....

165      None  
 205     Trans Share   Exclu   262161 45045
 434     Trans Share   Exclu   262161 45045
    66   Trans Exclusi Exclu  1114185 46270
 441     Trans Share   Exclu   262161 45045
 226     Trans Exclusi Exclu   262161 45045
....

Thanks,
Boris Dali.


Post your free ad now! http://personals.yahoo.ca

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Mon Feb 09 2004 - 14:09:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US