Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-04024: self-deadlock detected while trying to mutex pin cursor 0x456C0E9B8

OU_230Jul 13 2016 — edited Jul 13 2016

I am using Oracle 12.1.0.2. Enterprise edition. I am getting above error from application when running dynamic sql. Even after multiple retry it was throwing same error. The sql runs fine when executing from sqlplus. How to debug for the root cause ? Can I trace it or find what cursor 0x456C0E9B8 mean?

There are no blocking lock in the database.

No object are invalid.

Did not see anything in alert.log

There SQL does not involve any SQL profile or baseline.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 10 2016

Added on Jul 13 2016

#general-database-discussions

8 comments

968 views