Database Administration (MOSC)

MOSC Banner

Problems with deadlocks?

edited Jun 13, 2018 4:44PM in Database Administration (MOSC) 2 commentsAnswered
 

 Hi,

We have a problem with deadlocks in a Oracle 9.2.0.6 database. I have looked in several trc-file and mostly it looks like this

DEADLOCK DETECTED
Current SQL statement for this session:
UPDATE T_WO_WORKORDER SET BLEND = TO_CHAR(:B2 ) WHERE ORDERNO = :B1
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
42AB3B44        62  procedure GSS2_USAWES_DBO.P_WO_SETPRESSDATABLEND
44AFD1E8         1  anonymous block
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. The following
information may aid in determining the deadlock:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center