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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
