Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Slow Insert performance problem with Sqlplus
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 DBAReceived on Wed Oct 01 2003 - 15:36:47 CDT