"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
Oracle Database - Enterprise Edition - Version 22.214.171.124 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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.