Re: MERGE statement with parallel DML enabled deadlocks itself

From: Thomas Kellerer <>
Date: Thu, 07 May 2015 07:37:41 +0200
Message-ID: <>

Mohamed Houri schrieb am 06.05.2015 um 21:10:
> Just to rule out a possible deadlock situation I have observed
> recently which is due to an update of the partition key which causes
> the partition to move and locked the whole table as a consequence.
> You are not updating the partition key? right?

No, we are not updateing the partition key (or the primary key).

Received on Thu May 07 2015 - 07:37:41 CEST

Original text of this message