Re: Deadlock and ORA-0600 ocurred yesterday

вс, 25 мар. 2018 г., 7:22 Mladen Gogala <gogala.mladen_at_gmail.com>:

> Reply in-line
>
> On 03/24/2018 10:21 PM, Sayan Malakshinov wrote:
>
> Mladen,
>
> Update statement doesn't support "order by" and I almost never seen anyone
> write sorted update statements like
> update (select * from t where b=:b order by rowid) set d=:d
> So you can easily get deadlock with simple concurrent updates like
> "update t set d=:d where b=:b" and "update t set d=:d where c=:c"
>
>
> How would you get a deadlock on locking a single row in a single table?
>

I thought it's obvious that when I say about sorted updates(order by) I mean updating multiple rows...

>

--
http://www.freelists.org/webpage/oracle-l