Re: MERGE statement with parallel DML enabled deadlocks itself
From: Thomas Kellerer <thomas.kellerer_at_mgm-tp.com>
Date: Thu, 07 May 2015 07:37:41 +0200
Message-ID: <554AFA25.8000002_at_mgm-tp.com>
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?
Date: Thu, 07 May 2015 07:37:41 +0200
Message-ID: <554AFA25.8000002_at_mgm-tp.com>
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).
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 07 2015 - 07:37:41 CEST