"ORA-04024: Self-deadlock detected while trying to mutex pin cursor" on AUD_OBJECT_OPT$ With SQL Plan Management (SPM) Enabled
Last updated on FEBRUARY 10, 2017
Applies to: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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms