I think that if you have 100% CPU usage you need to tune the application,
but since you are already doing a rewrite adding CPU's seems in order.
You probably will need to increase memory as well and you may find new
bottlenecks, but I will try to solve one bottleneck in time.
Yechiel Adar
Mehish
> ----- Original Message -----
> From: "DENNIS WILLIAMS" <DWILLIAMS_at_LIFETOUCH.COM>
> To: <oracle-l_at_freelists.org>
> Sent: Thursday, September 23, 2004 10:34 PM
> Subject: Effect of adding more CPUs
>
>
> > List - We are trying to guess the benefit from doubling the CPUs on a
> > server, from 2 to 4. Will this increase the performance or just result
in
> an
> > I/O bottleneck? This server supports a production application and the
> season
> > of heavy usage is approaching. A development team is writing the
> replacement
> > application, so we are just looking at something to increase the
capacity
> > for this season. In addition to Oracle, a piece of the application runs
on
> > the server.
> > During the production season, the CPU remains pegged at 100 percent
> most
> > of the 24-hour cycle. But if you look at the overall Oracle wait times,
db
> > file sequential read is about 80% of the wait. I have read Cary's book
and
> > suggested running a 10046 trace, but would like input on the best
> approach.
> > Thanks.
> >
> >
> >
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 24 2004 - 00:58:45 CDT
