Re: Deadlock and ORA-0600 ocurred yesterday
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 25 Mar 2018 13:29:07 -0400
Message-ID: <0b5e20d9-2600-ba9a-ff28-636253d0135a_at_gmail.com>
Date: Sun, 25 Mar 2018 13:29:07 -0400
Message-ID: <0b5e20d9-2600-ba9a-ff28-636253d0135a_at_gmail.com>
Well, I would call an application which would run multiple simultaneous batch updates of the same data set a bad design. That is precisely what I've been saying. Deadlocks are a symptom of bad application design.
On 03/25/2018 02:37 AM, Sayan Malakshinov wrote:
>
>
>
> I thought it's obvious that when I say about sorted updates(order by)
> I mean updating multiple rows...
>
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Sun Mar 25 2018 - 19:29:07 CEST