Re: Insert Records - Performance Problem

From: G.H VITTAL <vittal_at_india.hp.com>
Date: Mon, 24 May 1999 19:01:05 +0530
Message-ID: <37495499.D6861A4D@india.hp.com>

Are both production and development are identical in all aspects ? One reason may be due to disk contention. Are there too many indexes on the prodcution table which for every insert of a record to the table it has update all it's indexes ? Definitely production table will have more number of records. Check also the size of the rollback segments. regards
vittal

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
Received on Mon May 24 1999 - 08:31:05 CDT