ORA-4021 Raised During COMMIT And Message "qsmqChkOCMV : Timeout while locking object" Appears In Alert.log
(Doc ID 2615963.1)
Last updated on DECEMBER 10, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Oracle Database - Standard Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
ORA-4021 "timeout occurred while waiting to lock object" error was raised during COMMIT of a transaction which modified a table which is a master of a materialized view.
At that time, message "qsmqChkOCMV : Timeout while locking object:XXXXX" was printed in the alert.log.
Issue may occur on release 188.8.131.52 and onwards. User may experience this issue after upgrading to 184.108.40.206.
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