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 -> Insert Records - Performance Problem

Insert Records - Performance Problem

From: <kmyu_at_my-dejanews.com>
Date: Tue, 20 Apr 1999 18:34:22 GMT
Message-ID: <7fihbe$6it$1@nnrp1.dejanews.com>


I have a problem in inserting records into Oracle 8. I have two machine, one for development and one for production and they have similar setting. The development machine takes only 0.8 sec to insert 1000 record, but the production machine takes 23 minutes to finish the same task. Is there any clue why there is different? I checked for the init.ora. They have similar parameters.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 20 1999 - 13:34:22 CDT

Original text of this message

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