Re: application deadlock ORA-00060

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 16 Apr 2008 09:34:15 -0700
Message-ID: <bf46380804160934k60336990nfcb9acc746176493@mail.gmail.com>

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_at_gmail.com> wrote:

> The root cause of the deadlock was a missing index on a FK.
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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

Received on Wed Apr 16 2008 - 11:34:15 CDT

This message: [ Message body ]
Next message: TESTAJ3_at_nationwide.com: "Re: ASM - hardware mirroring vs. Oracle mirroring"
Previous message: TESTAJ3_at_nationwide.com: "Re: Error recovering a database with a read-only tablespace"
In reply to: sol beach: "Re: application deadlock ORA-00060"
Next in thread: Yong Huang: "RE: application deadlock ORA-00060"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message