Re: Insert Records - Performance Problem

The first place I would check is how my datafiles are organized, and where these files are located. If the physical configurations for both machines are the same, then I have two questions:

1. Are these inserts through sqlload, SQL*Plus or as part of a 'create table ... as select ...' operation?
2. In the case of 'create table ... as select ...' did you install parallel query on one machine and not the other?

Also, check if your rollback segments and archive logs are on the same disk, or if your tables and indexes are on the same disk on one machine. Are your block sizes the same? There are a number of reasons why this could occur -- if you could provide more information about both systems it would certainly help.

David Fitzjarrell
In article <7fihbe$6it$1_at_nnrp1.dejanews.com>,   kmyu_at_my-dejanews.com wrote:
> 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
>

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