wait event name for deferred constraints
From: McPeak, Matt (Consultant) <"McPeak,>
Date: Fri, 31 Jan 2020 18:30:28 +0000
Message-ID: <BN8PR04MB5569E846C3D81A7CDAC45ED0DD070_at_BN8PR04MB5569.namprd04.prod.outlook.com>
If I have "FAST REFRESH ON COMMIT" materialized view, multiple sessions causing refreshes may experience an "enq: JI - contention" wait event.
Date: Fri, 31 Jan 2020 18:30:28 +0000
Message-ID: <BN8PR04MB5569E846C3D81A7CDAC45ED0DD070_at_BN8PR04MB5569.namprd04.prod.outlook.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 31 2020 - 19:30:28 CET