Re: alter table move partition - row cache lock

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:
> ALTERTABLEtmovePARTITIONpTABLESPACEtROWstoreCOMPRESSadvancedloblstoreAS(COMPRESSmediumTABLESPACEtl)
> UPDATEINDEXESPARALLEL8;
>
> -> 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