RE: alter table move partition - row cache lock
Date: Fri, 26 Feb 2021 09:21:28 -0500
Message-ID: <49bf01d70c4a$ac986260$05c92720$_at_rsiz.com>
Is this non-RAC?
Is this RAC, but force local instance for parallel?
Is this RAC non-local?
How many query “slaves?”
I believe that hashes the useful research options of why you are seeing a non-propagated lock held by the co-ordinator.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Laurentiu Oprea
Sent: Friday, February 26, 2021 7:59 AM
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;
-> the blocker is actual query coordinator who is idle all this time
Much appreciated,
Laurentiu.
To: ORACLE-L (oracle-l_at_freelists.org)
Subject: alter table move partition - row cache lock
-> one query slave remain stuck into wait "row cache lock" (p2 = 0, p3 =3)
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 26 2021 - 15:21:28 CET