Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Deadlock ( holds: S, waits: SSX )

586516Aug 1 2008 — edited Aug 6 2008

Hello,

I have a deadlock problem on a database.

Here is a summary of dump trace:

Dump file /home/migtt2/appli/expl/udump/migtt2_ora_1024024.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
System name: AIX
Release: 3
Version: 5
Instance name: MIGTT2

Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TM-0003ad7d-00000000 24 568 S SSX 26 577 S SSX
TM-0003ad7d-00000000 26 577 S SSX 24 568 S SSX

3ad7d identifies a table T1.

update T1 set .. where MSGOID=:13 and MSGINSTVERSION=:14
update T1 set .. where MSGOID=:13 and MSGINSTVERSION=:14

After reading on Metalink and studying concepts of lock in Oracle documentation, I have no explanation about this deadlock.

Could you help me.

Thanks.

Stéphane.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 3 2008

Added on Aug 1 2008

#general-database-discussions

12 comments

6,405 views