Re: Deadlock and ORA-0600 ocurred yesterday
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Sun, 25 Mar 2018 06:37:14 +0000
Message-ID: <CAOVevU43gdNSAA_kCPsYftk+quGDHM0BGS1RosMT8KSxcyFkNA_at_mail.gmail.com>
Date: Sun, 25 Mar 2018 06:37:14 +0000
Message-ID: <CAOVevU43gdNSAA_kCPsYftk+quGDHM0BGS1RosMT8KSxcyFkNA_at_mail.gmail.com>
вс, 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?
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Mar 25 2018 - 08:37:14 CEST