Re: looping cursor on a query hangs.
From: Mladen Gogala <mladen_at_bogus.email.com>
Date: Sat, 2 May 2009 01:21:50 +0000 (UTC)
Message-ID: <gtg77e$jgq$1_at_solani.org>
On Fri, 01 May 2009 13:03:28 -0700, Joyce wrote:
Date: Sat, 2 May 2009 01:21:50 +0000 (UTC)
Message-ID: <gtg77e$jgq$1_at_solani.org>
On Fri, 01 May 2009 13:03:28 -0700, Joyce wrote:
> Is it reasonable for Oracle to hang on a query like this? Basically,
> it's a cursor on a query which splits csv entries, and using the
> splitted up values to insert into another table. Does it hang because
> my table is too large? what is a better way that I can accomplish what
> I'm trying to do here? thank you, Joyce
Joyce, there are 2 tables that will tell you where it hangs and why it hangs:
V$SESSION_WAIT will tell you what is your session waiting on V$SESSION_EVENT will tell you what was your session waiting on, since
its creation.
Also, you can try doing explain plan on the SQL and then show us the result. Version information and the table structures, along with the availability of indexes, would also be very helpful.
-- http://mgogala.freehostia.comReceived on Fri May 01 2009 - 20:21:50 CDT