OraFAQ Forum: Performance Tuning » Help me find the SQL using hash value? (ORA-00060)

Home » RDBMS Server » Performance Tuning » Help me find the SQL using hash value? (ORA-00060) (rdbms 10.2, sles10 x64, three node RAC)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help me find the SQL using hash value? (ORA-00060) [message #483093]

Thu, 18 November 2010 06:54

hristo
Messages: 258
Registered: May 2007

Senior Member

Hi!

Getting an ORA-00060 in our database. This is the alert log:


Wed Nov 10 08:01:54 2010
Global Enqueue Services Deadlock detected. More info in file
 /opt/oracle/admin/ngboot/bdump/ngboot1_lmd0_13119.trc.

This is part of the lmd file:


oprocp           : (nil)
opid             : 0
group lock owner : (nil)
xid              : 0000-0000-00000000
dd_time          : 0.0 secs
dd_count         : 0
timeout          : 0.0 secs
On_timer_q?      : N
On_dd_q?         : N
lock_state       : GRANTED
Open Options     :  KJUSERNO_XID
Convert options  : KJUSERGETVALUE
History          : 0x97d497ad
Msg_Seq          : 0x1
res_seq          : 134054
valblk           : 0x00000000000000000000000000000000 .
user session for deadlock lock 0xa93996ec
  pid=189 serial=12570 audsid=0 user: 726/ARGUS
  O/S info: user: oracle, term: UNKNOWN, ospid: 30474, machine: lxrac01
            program: oracle@lxrac01 (J005)
  application name: DBMS_SCHEDULER, hash value=2478762354
  action name: BATCHA_PLOCK, hash value=3180952482
  Current SQL information unavailable
Global Wait-For-Graph(WFG) at ddTS[0.39cc] :
BLOCKED 0xa93c2a3c 5 [0x90001][0x2fa607],[TX] [3D000-0003-0023CF2B] 2
BLOCKER 0xaae1069c 5 [0x90001][0x2fa607],[TX] [BD000-0001-000F0B74] 0
BLOCKED 0xa93996ec 5 [0x12f001e][0x918da],[TX] [BD000-0001-000F0B74] 0
BLOCKER 0xa93c0320 5 [0x12f001e][0x918da],[TX] [3D000-000e3-0023CF2B] 2

How do I find the SQL causing this? I have the hash value of 3180952482. Can that help me? Or should I open up en SR as this i logged in an lmd trace?

[Updated on: Thu, 18 November 2010 07:20]

Report message to a moderator