Re: sqlplus & exp "hanging" on a particular table
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 12 Oct 2011 13:56:23 +0000 (UTC)
Message-ID: <pan.2011.10.12.13.56.23_at_gmail.com>
On Wed, 12 Oct 2011 09:26:20 +0100, Jeremy wrote:
Date: Wed, 12 Oct 2011 13:56:23 +0000 (UTC)
Message-ID: <pan.2011.10.12.13.56.23_at_gmail.com>
On Wed, 12 Oct 2011 09:26:20 +0100, Jeremy wrote:
> SQL> create PROBLEM_TABLE as select * from PROBLEM_TABLE_at_db11;
> [NOTHING!]
Did you check for wait events? What does "hanging" means? What events do
you see in V$SESSION? Is it waiting? Doing something? Tracing the
background process by turning on 10046 would also be a good idea.
-- http://mgogala.byethost5.comReceived on Wed Oct 12 2011 - 08:56:23 CDT