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 -> Re: Slow Insert performance problem with Sqlplus

Re: Slow Insert performance problem with Sqlplus

From: Erik <no_at_spam.com>
Date: Thu, 2 Oct 2003 18:40:39 +0200
Message-ID: <blhkgq$rft$1@news.lth.se> 





> 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.




Expensive triggers?
Received on Thu Oct 02 2003 - 11:40:39 CDT












Original text of this message













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