Trace file /opt/oracle/diag/rdbms/racdb/racdb2/trace/racdb2_j000_7415.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /opt/oracle/product/11.2.0/db_1
System name: Linux
Node name: zslgbdb2
Release: 2.6.18-194.el5
Version: #1 SMP Tue Mar 16 21:52:39 EDT 2010
Machine: x86_64
Instance name: racdb2
Redo thread mounted by this instance: 2
Oracle process number: 684
Unix process pid: 7415, image: [url=mailto
racle@zslgbdb2]oracle@zslgbdb2[/url] (J000)
*** 2012-04-17 00:00:00.392
*** SESSION ID
1143.2780) 2012-04-17 00:00:00.392
*** CLIENT ID
) 2012-04-17 00:00:00.392
*** SERVICE NAME
SYS$USERS) 2012-04-17 00:00:00.392
*** MODULE NAME
DBMS_SCHEDULER) 2012-04-17 00:00:00.392
*** ACTION NAME
QUEST_PPCM_JOB_PM_2) 2012-04-17 00:00:00.392
Single resource deadlock: blocking enqueue which blocks itself, f 0
Granted global enqueue 0x5d9c27b18
----------enqueue 0x5d9c27b18------------------------
lock version : 1
Owner node : 0
grant_level : KJUSERCW
req_level : KJUSERPW
bast_level : KJUSERNL
notify_func : 0x408305c
resp : 0x5d2755968
procp : 0x62200eb18
pid : 0
proc version : 4
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 : 0xd7d8d7da
Msg_Seq : 0x1b0019
res_seq : 1
valblk : 0x000000000000000000000000ff7f0000 .
DUMP LOCAL BLOCKER/HOLDER: block level 4 res [0x12a73][0x0],[TM]
----------resource 0x5d2755968----------------------
resname : [0x12a73][0x0],[TM]
Local node : 1
dir_node : 1
master_node : 1
hv idx : 71
hv last r.inc : 2
current inc : 4
hv status : 0
hv master : 1
open options : dd cached
grant_bits : KJUSERCW
grant mode : KJUSERNL KJUSERCR KJUSERCW KJUSERPR KJUSERPW KJUSEREX
count : 0 0 2 0 0 0
val_state : KJUSERVS_NOVALUE
valblk : 0x0000000030000000a010fa47ff7f0000 .0G
access_node : 1
vbreq_state : 0
state : x0
resp : 0x5d2755968
On Scan_q? : N
cache level : 0
Total accesses: 1300
Imm. accesses: 1290
Granted_locks : 1
Cvting_locks : 1
value_block: 00 00 00 00 30 00 00 00 a0 10 fa 47 ff 7f 00 00
GRANTED_Q :
lp 0x612d64698 gl KJUSERCW rp 0x5d2755968 [0x12a73][0x0],[TM]
master 1 gl owner 0x6218dbfc8 possible pid 7415 xid 2AC000-0002-00000DD3 bast 0 rseq 1 mseq 0 history 0x49a51495
open opt KJUSERDEADLOCK
CONVERT_Q:
lp 0x5d9c27b18 gl KJUSERCW rl KJUSERPW rp 0x5d2755968 [0x12a73][0x0],[TM]
master 1 owner 0 bast 1 rseq 1 mseq 0x1b0019 history 0xd7d8d7da
convert opt KJUSERGETVALUE
----------enqueue 0x612d64698------------------------
lock version : 1703
Owner node : 1
grant_level : KJUSERCW
req_level : KJUSERPW
bast_level : KJUSERNL
notify_func : (nil)
resp : 0x5d2755968
procp : 0x6220ecc18
pid : 7415
proc version : 222
oprocp : (nil)
opid : 7415
group lock owner : 0x6218dbfc8
possible pid : 7415
xid : 2AC000-0002-00000DD3
dd_time : 0.0 secs
dd_count : 0
timeout : 0.0 secs
On_timer_q? : N
On_dd_q? : N
lock_state : CONVERTING
Open Options : KJUSERDEADLOCK
Convert options : KJUSERGETVALUE
History : 0x49a51495
Msg_Seq : 0x0
res_seq : 1
valblk : 0x00000000000000000000000000000000 .
user session for deadlock lock 0x612d64698
sid: 1143 ser: 2780 audsid: 105539840 user: 87/SPOTLIGHT flags: 0x310041
pid: 684 O/S info: user: oracle, term: UNKNOWN, ospid: 7415
image: [url=mailto
racle@zslgbdb2]oracle@zslgbdb2[/url] (J000)
client details:
O/S info: user: oracle, term: UNKNOWN, ospid: 7415
machine: zslgbdb2 program: [url=mailto
racle@zslgbdb2]oracle@zslgbdb2[/url] (J000)
application name: DBMS_SCHEDULER, hash value=2478762354
action name: QUEST_PPCM_JOB_PM_2, hash value=100257142
current SQL:
DELETE FROM QUEST_PPCM_SNAPSHOT WHERE SNAPSHOT_TYPE = :B2 AND INSTANCE_ID > 0 AND SNAPSHOT_TIMESTAMP < TRUNC (SYSDATE) - :B1
----------enqueue 0x5d9c27b18------------------------
lock version : 1
Owner node : 0
grant_level : KJUSERCW
req_level : KJUSERPW
bast_level : KJUSERNL
notify_func : 0x408305c
resp : 0x5d2755968
procp : 0x62200eb18
pid : 0
proc version : 4
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 : 0xd7d8d7da
Msg_Seq : 0x1b0019
res_seq : 1
valblk : 0x000000000000000050d7990a00000000 .P
Requesting global enqueue 0x612d64698
----------enqueue 0x612d64698------------------------
lock version : 1703
Owner node : 1
grant_level : KJUSERCW
req_level : KJUSERPW
bast_level : KJUSERNL
notify_func : (nil)
resp : 0x5d2755968
procp : 0x6220ecc18
pid : 7415
proc version : 222
oprocp : (nil)
opid : 7415
group lock owner : 0x6218dbfc8
possible pid : 7415
xid : 2AC000-0002-00000DD3
dd_time : 0.0 secs
dd_count : 0
timeout : 0.0 secs
On_timer_q? : N
On_dd_q? : N
lock_state : CONVERTING
Open Options : KJUSERDEADLOCK
Convert options : KJUSERGETVALUE
History : 0x49a51495
Msg_Seq : 0x0
res_seq : 1
valblk : 0x28d00e2206000000e014fa47ff7f0000 ("G
user session for deadlock lock 0x612d64698
sid: 1143 ser: 2780 audsid: 105539840 user: 87/SPOTLIGHT flags: 0x310041
pid: 684 O/S info: user: oracle, term: UNKNOWN, ospid: 7415
image: [url=mailto
racle@zslgbdb2]oracle@zslgbdb2[/url] (J000)
client details:
O/S info: user: oracle, term: UNKNOWN, ospid: 7415
machine: zslgbdb2 program: [url=mailto
racle@zslgbdb2]oracle@zslgbdb2[/url] (J000)
application name: DBMS_SCHEDULER, hash value=2478762354
action name: QUEST_PPCM_JOB_PM_2, hash value=100257142
current SQL:
DELETE FROM QUEST_PPCM_SNAPSHOT WHERE SNAPSHOT_TYPE = :B2 AND INSTANCE_ID > 0 AND SNAPSHOT_TIMESTAMP < TRUNC (SYSDATE) - :B1
spolit怎么会产生死锁