oracle死锁 重启可以吗,一个ORACLE死锁问题的追踪

PARSING IN CURSOR #27 len=153 dep=1 uid=69 oct=6 lid=69 tim=1233331432659515 hv=3592496474 ad='46e29a38'

UPDATE PM_USER_TEMP T SET T.DEFAULTROLENAME = 'core.pm/label.companyAdministrator' WHERE T.DEFAULTROLENAME = :B3 AND T.USERID = :B2 AND T.FILENAME = :B1

END OF STMT

PARSE #27:c=0,e=282,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,tim=1233331432659507

DEADLOCK DETECTED

[Transaction Deadlock]

Current SQL statement for this session:

UPDATE PM_USER_TEMP T SET T.DEFAULTROLENAME = 'core.pm/label.companyAdministrator' WHERE T.DEFAULTROLENAME = :B3 AND T.USERID = :B2 AND T.FILENAME = :B1

----- PL/SQL Call Stack -----

objectlineobject

handlenumbername

0x3d26c364470procedure XPC92_IMPORT_JEFF.AIT_LOADTEMPDATA

0x3d26c51c1anonymous 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:

Deadlock graph:

---------Blocker(s)-----------------Waiter(s)---------

Resource Nameprocess session holds waitsprocess session holds waits

TX-0009000d-0000207b38721X38721X

session 721: DID 0001-0026-00001DE8session 721: DID 0001-0026-00001DE8

Rows waited on:

Session 721: obj - rowid = 0000EAF8 - AAAPzHAAGAAAVGzAAA

(dictionary objn - 60152, file - 6, block - 86451, slot - 0)

Information on the OTHER waiting sessions:

End of information on OTHER waiting sessions.

===================================================

PROCESS STATE

-------------

Process global information:

process: 0x4cf5d02c, call: 0x496db50c, xact: 0x4b1bbd4c, curses: 0x4cbcf25c, usrses: 0x4cbcf25c

----------------------------------------

SO: 0x4cf5d02c, type: 2, owner: (nil), flag: INIT/-/-/0x00

(process) Oracle pid=38, calls cur/top: 0x496db50c/0x4970dcdc, flag: (0) -

int error: 0, call error: 0, sess error: 0, txn error 0

(post info) last post received: 108 0 4

last post received-location: kslpsr

last process to post me: 4cf519ac 1 6

last post sent: 0 0 24

last post sent-location: ksasnd

last process posted by me: 4cf519ac 1 6

(latch info) wait_event=0 bits=10

holding(efd=19) 20004fc4 Parent+children enqueue hash chains level=4

Location from where latch is held: ksqcmi: kslgpl:

Context saved from call: 0

state=busy, wlstate=free

recovery area:

…..此外省略n行