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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,196 views