Re: Foreign key constraint enable hangs (Ver. 9204)

From: Jared Still <jkstill_at_gmail.com>
Date: Sun, 7 Nov 2004 10:45:06 -0800
Message-ID: <bf463804110710457d52907@mail.gmail.com>

10046 trace comes to mind. It may give some indications as to what has happened, or is happening.

Have you checked v$sess_io?

You can see if IO is taking place in the session.

truss or strace may also be useful.

Jared

On Sat, 06 Nov 2004 23:58:57 -0800, Jonathan Redshaw <jbredsh_at_msn.com> wrote:
> I am having a specific problem when trying to enable a foreign key
> constraint on a medium sized table (300K) rows. The enable constraint is
> hanging and I don't see any lock conflicts. Any advice on how to
> troubleshoot would be appreciated.
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l

Received on Sun Nov 07 2004 - 12:41:53 CST