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: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 01 Oct 2003 22:36:47 +0200
Message-ID: <mkemnv8a9os4k232014nn5cr4ke57eeo9a@4ax.com>


On Wed, 1 Oct 2003 16:55:37 GMT, "Robert" <stop.spam_at_whitehouse.gov> wrote:

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

Do you have any other information other than 'it doesn't work' Your 30,000 records may be 2k each and your 135,000 records may be 10 bytes each. You're not proving anything, and you're not providing any clue.

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Oct 01 2003 - 15:36:47 CDT

Original text of this message

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