Enq: MS - Contention When Using Timestamp-based Mview Log
(Doc ID 2555801.1)
Last updated on APRIL 01, 2021
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
Mview is using "Timestamp-based Mview Log", and occasionally lots of select and insert statement are blocked by "Enq: MS - Contention" when J000 process is refreshing the MVIEW, the session held MS enqueue is performing below SQL statement:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document