Re: Insert Records - Performance Problem

As a addendum to this You might have disabled the indexes/constraints when loading the data in the first machine but you might have enabled in the other machine so that it is taking more time every time you add new record the index keeps rebuilding

regards
vittal

ddf_dba_at_my-dejanews.com wrote:

> 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 Sat May 08 1999 - 03:39:28 CDT