Re: application deadlock ORA-00060

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: sol.beach@xxxxxxxxx
  • Date: Wed, 16 Apr 2008 09:34:15 -0700

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

Other related posts: