Re: Deadlock Question

Oracle10g 10.1.0.3 (64 bit)
Solaris 2.8 (64 bit)

Billy --> You are correct. As per Metalink Note:223303.1 in 9.2.0 and later versions, the foreign keys don't have to be indexed.

Could some one explain the following via an example.

Quote from J. Lewis: the problem of two processes trying to insert new rows into two tables, and crossing over in their use of uncommitted primary keys.

Quote from Metalink: what happens when you have deadlock on insert due to primary key overlap. This is relatively easy to reproduce, and results in
deadlock where each process holds X mode and waits on S mode. Also, row waited on is 'no row'.

Thanks for any pointers.
wagen

Billy wrote:
> wagen123_at_yahoo.com wrote:
> > Hi,
> >
> > Quote fron Steve Adams website - "you need indexes on all the foreign
> > key columns. Otherwise, you need table locks to be disabled on any
> > table that is missing a foreign key index"
>
> If I'm not mistaken this is no longer the case with 9i and later (the
> child table lock)
>
> One always has to be careful with articles on Oracle as Oracle is
> always elvolving and what was true a year or three ago may not be the
> case anymore. Can get quite "interesting" at times..
>
> --
> Billy
Received on Thu Jun 02 2005 - 14:37:22 CDT