Re: deadlocks , performance issues

  • From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
  • To: Mark.Bobak@xxxxxxxxxxxx
  • Date: Wed, 24 Aug 2011 14:33:52 +0200

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@xxxxxxxxx>*
    To: *"oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>*
    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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2011