"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 AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 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!