Re: performance issues

vissuyk_at_yahoo.com wrote:
> 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 exactly do you mean by "charts going upto 2 years?" If you are aggregating data that would be DSS rather than OLTP, and might be better off moving to another machine.

>
> 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.

What have you done so far to explicate the problem? Have you run statspacks? OEM performance manager? Other tools? Are you following any specific performance tuning methodology? Are you using the buffer recycle pool appropriately? (That last made all the difference in the world on one mixed-use machine I worked on.) Are you paging/swapping? Have you tuned your SQL?

Which OS are you on? How many users do you have at one time? Are you n-tier? What kind of programming are you doing? PL/SQL? Java? Portal? Some third-party thing? What modifications have you made to init.ora?

jg

--
@home.com is bogus.
"I thought it would be so fun to make the world a better place by
telling everyone about this"
http://www.signonsandiego.com/uniontrib/20051205/news_1n5lice.html