Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: insert into too slow

Re: insert into too slow

From: EdStevens <quetico_man_at_yahoo.com>
Date: Thu, 19 Jul 2007 13:30:14 -0700
Message-ID: <1184877014.954326.92210@d55g2000hsg.googlegroups.com> 





On Jul 19, 7:04 am, valigula <valig..._at_gmail.com> wrote:


> Hi all

>

> oracle 9i

> When i execute a "insert into select" it takes ages. It took yesterday

> over 3 hours with no results, but when i execute just the select it

> takes 30 sec. has anyone has a similar problem.

>

> I did not post the query since cross several tables and use a few

> cases withing the select.




Take a 10046 trace and examine the results.
Received on Thu Jul 19 2007 - 15:30:14 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US