performance issues

From: <vissuyk_at_yahoo.com>
Date: 5 Dec 2005 12:14:20 -0800
Message-ID: <1133813660.198912.243640@g14g2000cwa.googlegroups.com>

Hi All,

We are having issues with OLTP scalability. I am sure it is my implementation of db. We have one machine with 2 cpus (3Gig Hz) and about 16 drives. One table is about 10 Million rows. Queries and DML are taking place Updates are killing us. We are seeing about 10-20 updates per sec. We are on 10g R1. This table has about 4 indexes. This looks like IO related. We also provide charts going upto 2 years. How to solve these issues ?.

What kind of IO hardware can scale upto this ?. We want updates to be very fast. I have been thinking of solid state disks, but they are very expensive.

Thanks for any help

Vissu Received on Mon Dec 05 2005 - 14:14:20 CST