Re: Insert performance problem

From: <Jared.Still_at_radisys.com>
Date: Thu, 17 Jun 2004 13:15:35 -0700
Message-ID: <OFAC3C9CFE.B6D54370-ON88256EB6.006F356C-88256EB6.006F4827@radisys.com>

Run a 10046 level 8 trace and see where the time is spent.

"Harvinder Singh" <Harvinder.Singh_at_MetraTech.com> Sent by: oracle-l-bounce_at_freelists.org
06/17/2004 12:23 PM
Please respond to
oracle-l_at_freelists.org

To
<oracle-l_at_freelists.org>
cc

Subject
Insert performance problem

Hi,  

We are testing a application prototype and inserting 1000 rows from 1 table and populating into 2nd table in a loop and inserting 1M rows. 2nd table have primary key on 2 column, 1 column unique key and 1 non-unique index on 6 columns
We are seeing tps of only about 5000 whereas if I run same test on sql server tps is between 15000 to 20000  

Following are the stats on the machine:
Oracle 10g on win2k
Writing to hard disk having all the datafiles(raid 5) :Avg disk bytes/write 9000 and 13000

Writing to hard disk having log files                 :Avg disk 

bytes/write 48000 and 70000    

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Jun 17 2004 - 15:12:54 CDT