RE: Effect of adding more CPUs

Dennis,

        If your CPU is pegged & the io subsystem (check %WIO in SAR) is not a = big problem, then you may benefit from more CPU's. But don't forget to = weigh that against the increase in cost for Oracle. Assuming Enterprise = edition: 2 CPU's =3D $80K, 4 cpu's =3D $160K. OUCH, damn I hate that!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----

From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM] Sent: Thursday, September 23, 2004 4:34 PM To: 'oracle-l_at_freelists.org '
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.=20

    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.

=20

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 23 2004 - 16:32:45 CDT