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]

Hi Samid,

Already suggested by others experts, this is completely related with developer team as the issue comes on customized Z table.And for mentioned error

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

I suggest you to work out for below at your end :

There are several causes for this error:

Too high activity - Re-running the job during a less busy period can fix this ORA-00060 deadlock error.
Poor application design - As noted in the trace file:  "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." 



RAM shortage - In rare cases this ORA-00060 deadlock error can happen with a RAM shortage at the Java layer or Oracle layer.

Regards,

Gaurav