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 -> insert into too slow

insert into too slow

From: valigula <valigula_at_gmail.com>
Date: Thu, 19 Jul 2007 05:04:15 -0700
Message-ID: <1184846655.754365.92050@r34g2000hsd.googlegroups.com> 





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.
Received on Thu Jul 19 2007 - 07:04:15 CDT












Original text of this message













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