Re: SKIP LOCKED on RAC
From: Andy Klock <andy_at_klockmail.com>
Date: Mon, 22 Nov 2021 20:52:10 +0000
Message-ID: <m2k0gzoqvd.fsf_at_klockmail.com>
Date: Mon, 22 Nov 2021 20:52:10 +0000
Message-ID: <m2k0gzoqvd.fsf_at_klockmail.com>
"Mladen Gogala" <gogala.mladen_at_gmail.com> writes:
> I know that SELECT FOR UPDATE SKIP LOCKED is not supported
> across the RAC instances but I am unable to find any Oracle
> documentation documenting that behavior. Can anybody help?
I can understand leaning towards writing the application to avoid concurrent updates from different instances, but I wasn't aware that SELECT FOR UPDATE SKIP LOCKED wasn't supported.
Andy K
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 22 2021 - 21:52:10 CET