"ORA-04024: Self-deadlock detected while trying to mutex pin cursor" on AUD_OBJECT_OPT$ With SQL Plan Management (SPM) Enabled
(Doc ID 2039379.1)
Last updated on MAY 12, 2021
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
- An "ORA-04024: self-deadlock detected while trying to mutex pin cursor" error is being raised
- SQL that raises the error is:
- A SQL Plan Management (SPM) Baseline is defined on the query .
- The Functions kestb_lookup() and kzapObjSubCacheRead() are seen in the stack
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