See http://asktom.oracle.com/tkyte/unindex/unindex.sql This will located other unindexed FK's On Wed, Apr 9, 2008 at 3:31 PM, sol beach <sol.beach@xxxxxxxxx> wrote: > The root cause of the deadlock was a missing index on a FK. > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist