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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Laurentiu Oprea
Sent: Friday, February 26, 2021 7:59 AM
To: ORACLE-L (oracle-l@xxxxxxxxxxxxx)
Subject: alter table move partition - row cache lock
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.