Coincidentally I've just re-discovered some comments about the mechanisms of
deferrable constraints made by Valentin Nikotin on one of my blog notes from a
few years back:
https://jonathanlewis.wordpress.com/2012/09/04/online-rebuild-2/#comment-49904
You might find them interesting.
Regards
Jonathan Lewis
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of McPeak, Matt (Consultant) <vxsmimmcp@xxxxxxxxxx>
Sent: 31 January 2020 18:30
To: ORACLE-L
Subject: wait event name for deferred constraints
If I have “FAST REFRESH ON COMMIT” materialized view, multiple sessions causing
refreshes may experience an “enq: JI – contention” wait event.
I assume a similar serialization has to happen to enforce deferred constraints?
If that is true, does anyone know what the wait event would be?
Thanks!
Matt
--
//www.freelists.org/webpage/oracle-l