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

Home -> Community -> Usenet -> c.d.o.misc -> Slow Insert performance problem with Sqlplus

Slow Insert performance problem with Sqlplus

From: Robert <stop.spam_at_whitehouse.gov>
Date: Wed, 1 Oct 2003 16:55:37 GMT
Message-ID: <HM38Co.C97@news.boeing.com> 





I am working on a performance problem with database inserts. The delivery
system is an HP 7410 running 11.11 and Oracle v8.1.7.4. The data load is
being done via sqlplus from an NT server using a database connection. The
insert took 2 hours to complete 30,000 records versus 135,000 records that
took 2 minutes on a different table. Has anyone encountered anything simliar
to this? Thanx in advance.
Received on Wed Oct 01 2003 - 11:55:37 CDT












Original text of this message













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