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: PL/SQL insert performance

Re: PL/SQL insert performance

From: Grinalds <g.geks_at_konts.v>
Date: Fri, 08 May 1998 15:53:11 +0200
Message-ID: <35530036.52BF427E@konts.NOSPAM.v> 





think about partitioned views.


 



> PROBLEM:  As the table grows in size, the daily insert procedure is taking a


> rapidly increasing amount of time to complete.  Execution time has gone from 1


> hour a couple of months ago (approx 5 million existing rows back then) to over


> 8 hours today.





 

Received on Fri May 08 1998 - 08:53:11 CDT












Original text of this message













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