Hello,
I'm facing a very strange problem on a Forms 11g server.
From time to time, frmweb process creates big file frmweb999.out in /tmp with the endless message as here-below :
ORA-04020: deadlock detected while trying to lock object /XWEBUTIL^AWEBUTIL_CORE
I can't find what is the cause of this problem.
How can Forms have a ORA-04020 deadlock on WEBUTIL_CORE which don't even exist in the DB ?!
Thanks in advance for your help.
Forms Server version is 11.1.2
Weblogic Server is 10.3.6
Oracle DB version is 11.2.0.4.0
Full message:
A deadlock among DDL and parse locks is detected.
This deadlock is usually due to user errors in
the design of an application or from issuing a set
of concurrent statements which can cause a deadlock.
This should not be reported to Oracle Support.
The following information may aid in finding
the errors which cause the deadlock:
ORA-04020: deadlock detected while trying to lock object /XWEBUTIL^AWEBUTIL_CORE
--------------------------------------------------------
object waiting waiting blocking blocking
handle session lock mode session lock mode
-------- -------- -------- ---- -------- -------- ----
0xee4c258 0xed4fd10 0xf164888 X 0xed4fe08 0xeebbcc8 S
--------------------------------------------------------
---------- DUMP OF WAITING AND BLOCKING LOCKS ----------
--------------------------------------------------------
------------- WAITING LOCK -------------
In-flux value for a lock at 0xf164888
------------- BLOCKING LOCK ------------
In-flux value for a lock at 0xeebbcc8
--------------------------------------------------------