Short dump DBIF_RSQL_SQL_ERROR

[Former Member]

Hello,

We are facing a short dump in the ERP Production system - DBIF_RSQL_SQL_ERROR.

We don't understand why this sometimes happens!

I sent to you attached to this message the short dump (DBIF_RSQL_SQL_ERROR.txt).

The error text in the database is this: ORA-00060: deadlock detected while waiting for resource

Can you help us please in way to understand how can we solve this error?

Thank you,

samid raif

DBIF_RSQL_SQL_ERROR.txt.zip

[former_member182657]

The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL

As per your current log you are getting above error which i pointed earlier in my reply.So first please share hardware details with us & re check for what this ZGLR_ASTREIN_EXPANSAO_MAT ? (Already pointed by RB )

Regards,

Gaurav