alter table move partition - row cache lock

From: Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
Date: Fri, 26 Feb 2021 14:59:03 +0200
Message-ID: <CA+riqSV=oeVRrnFDbvxgv1U7hB--kP=_2Zan-+WWAd4n2a+Gtg_at_mail.gmail.com>



Hello,

DB Version 12.0.1.2

I noticed a strange situation and I`m curios if someone faced a similar situation or have any clue about the reason:

While executing a partition move:
ALTER TABLE t move PARTITION p TABLESPACE t ROW store COMPRESS advanced lob l store AS (COMPRESS medium TABLESPACE tl) UPDATE INDEXES PARALLEL 8;
-> one query slave remain stuck into wait "row cache lock" (p2 = 0, p3 =3)
-> the blocker is actual query coordinator who is idle all this time

Much appreciated,
Laurentiu.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 26 2021 - 13:59:03 CET

Original text of this message