Database Tuning (MOSC)

MOSC Banner

Global Enqueue Services Deadlock detected.

edited Dec 26, 2011 2:20PM in Database Tuning (MOSC) 2 comments
Can somebody help me resolving the deadlock issue. 
Dump file /home/oraaiprd/OraHome/admin/bdump/aiprd1_lmd0_21508.trc
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
ORACLE_HOME = /home/oraaiprd/OraHome
System name:    Linux
Node name:      gitsipdb01.arg.ae
Release:        2.6.9-78.EL
Version:        #1 SMP Wed Jul 9 15:27:17 EDT 2008
Machine:        ia64
Instance name: AIPRD1
Redo thread mounted by this instance: 0 <none>
Oracle process number: 5
Unix process pid: 21508, image: oracle@gitsipdb01.arg.ae (LMD0)

*** SESSION ID:(4.1) 2011-12-23 04:08:19.757
 open lock on RM 0 0
 open lock on RM 0 0
*** 2011-12-23 06:13:07.096

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