Re: ORA-600 Deadlock Issues

> look up chapter 7 of tom kytes' book - Indexes on Foreign Keys. (page 142
> in my book).
>
> "The number one cause of deadlocks in the Oracle database, in my
> experience, is unindexed foreign keys" - says the Guru himself.

The next time you have a deadlock, check first the deadlock graph, for unindexed foregn keys it will be SX-SSX:

Deadlock graph:

                       ---------Blocker(s)--------  ---------Waiter(s)---------
Resource Name          process session holds waits  process session holds 
waits
TM-000010e0-00000000        14      40    SX   SSX       13      19    SX 
SSX
TM-000010e0-00000000        13      19    SX   SSX       14      40    SX 
SSX
session 40: DID 0001-000E-00000002      session 19: DID 0001-000D-00000002
session 19: DID 0001-000D-00000002      session 40: DID 0001-000E-00000002

Cheers
Dimitre Radoulov

--
http://www.freelists.org/webpage/oracle-l