Re: ITL and possible deadlocks

Ed,

Not sure that I understood it right, but I'll take a try. So there are 2 transactions and each one is trying to update the row which was already updated by the other transaction?
IMHO, if you are trying to place an exclusive lock on the locked row ( it remains locked until commit ), you either wait or receive an error if "no wait" was specified.
Behaviour of the 2nd transaction is trying to place an exclusive lock on the 1st transaction' row is just the same.
If both transactions wait, it's a deadlock situation and should be resolved by Oracle itself.

HTH,
Michael Netrusov,
www.atelo.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, March 20, 2001 10:40

> Hello List,
>
> it's rather a theoretical question. Let say two sessions
> update a table. Each transaction allocated a transaction
> slot in a block (I consider the two different blocks).
> Each block has only one slot and there is no free space
> in these blocks to allocate additional transaction slots.
> Then each transaction tryes to update a row in the block
> which has already been updated by the other transaction.
> How Oracle to do with such situation in case when there is
> no access to a common resource (I mean a common row) ?
>
>
> Thanks in advance
>
> Ed
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Shevtsov, Eduard
> INET: EShevtsov_at_flagship.ru
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael Netrusov
  INET: mn_at_g-fax.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).