Re: deadlocks , performance issues

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Wed, 24 Aug 2011 08:28:32 -0400
Message-ID: <a5841ce5-8376-47bb-8f8e-08356c64a7c8_at_blur>

Need more information. What types of SQL are involved? Insert? Update? Delete?

Do you have a table with child table that has unindexed FKs?

Sent from my Motorola ATRIX™ 4G on AT&T

-----Original message-----

From: mek s <sidi.bouzid.meknessy_at_gmail.com> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Wed, Aug 24, 2011 12:22:38 GMT+00:00 Subject: deadlocks , performance issues

Hello,

in 11gR2 and Solaris.

We are facing deadlock ORA-00060 errors; here the deadlock graph, any idea?

Deadlock graph:

                       ---------Blocker(s)--------  ---------Waiter(s)---------
Resource Name          process session holds waits  process session holds waits
TX-001a0002-0002a0fe       196     197     X            166    1835           S
TM-0000c800-00000000       166    1835    SX            196     197    SX   SSX

thank you,
S
--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 24 2011 - 07:28:32 CDT