ORA-4021 Raised During COMMIT And Message "qsmqChkOCMV : Timeout while locking object" Appears In Alert.log
(Doc ID 2615963.1)
Last updated on MARCH 12, 2021
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Oracle Database - Standard Edition - Version 18.104.22.168 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 22.214.171.124 and onwards. User may experience this issue after upgrading to 126.96.36.199.
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