Re: Deadlock and ORA-0600 ocurred yesterday
Date: Sun, 25 Mar 2018 00:22:08 -0400
Message-ID: <c00a54f5-e1b0-087e-4ac8-5e94bf34cf08_at_gmail.com>
Reply in-line
On 03/24/2018 10:21 PM, Sayan Malakshinov wrote:
How would you get a deadlock on locking a single row in a single table?
> 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"
>
> --
> Best regards,
> Sayan Malakshinov
> Oracle performance tuning engineer
> Oracle ACE Associate
> http://orasql.org
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Sun Mar 25 2018 - 06:22:08 CEST