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,
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-lReceived on Fri Feb 26 2021 - 13:59:03 CET