Re: deadlocks , performance issues

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Wed, 24 Aug 2011 14:33:52 +0200
Message-ID: <4E54EFB0.6050604_at_roughsea.com>



To add to Mark's list - triggers? bit-map indexes?
-- 
Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>


On 08/24/2011 02:28 PM, Bobak, Mark wrote:

> 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:33:52 CDT

Original text of this message