Re: alter table move partition - row cache lock

Hello Mark,

When connecting using a service, the parallel slaves will be spawned only on the instance/instances where service is started. Parallel_force_local will prevent parallel slaves from leaving the current instance.

I haven't tried yet hanganalyze, I just started to look into it, I was curious if someone faced a similar issue or had any clue.

Thanks

În vin., 26 feb. 2021 la 23:37, Lothar Flatz <l.flatz_at_bluewin.ch> a scris:

> Did you try a hanganalyze?
>
>
> Am 26.02.2021 um 13:59 schrieb Laurentiu Oprea:
>
> 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