Sorry I missed to provide full details. Yes this is RAC. Cache_id is 2
(dc_segments). Coordinator and query slaves (8) are all running on the same
instance (due to service configured for a single instance)
În vin., 26 feb. 2021 la 16:22, Mark W. Farnham <mwf@xxxxxxxx> a scris:
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.