Re: Foreign key constraint enable hangs (Ver. 9204)
- From: Jared Still <jkstill@xxxxxxxxx>
- To: jbredsh@xxxxxxx
- Date: Sun, 7 Nov 2004 10:45:06 -0800
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@xxxxxxx> 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.
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
