| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Any exp with NTw/2 to 4 procs?
Earl,
This may be a dumb question on my part, but are the existing CPUs maxed =
out?
Are they consistently more than 80% busy during important periods?
If so, adding CPUs would speed things up. If not, it probably won't.
How does the memory usage (Commit Charge, Peak Commit Charge) compare =
with
the amount of available physical RAM on the machine (Total Physical =
Memory,
and how much is currently Available) -- in Task Manager | Performance.
If you think it might be I/O then diskperf -y at the command line, =
reboot
(ha ha), and watch the disk I/O counters in Performance Monitor.=20
Adding memory may well speed up Oracle on NT because in NT each Oracle
instance is a multithreaded process. i.e. SMON, PMON, DBWR(s), LGWR =
are
separate threads and hence multitasked. I checked on one of my servers =
here
and every user connection to the database is a new thread under the =
instance
process.
Also remember that before adding hardware, are you sure that the SQL =
going
through is optimized, that the database design is good. =20
HTH
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des syst=E8mes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique=20 Maritimes Region, DFO | R=E9gion des Maritimes, MPO
E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
> -----Original Message-----
> From: The Oracle DBA [SMTP:theoracledba_at_lycos.com]
> Sent: Wednesday, December 06, 2000 10:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Any exp with NTw/2 to 4 procs?
>=20
> A client seems to be seeing now perf improv with adding 2 more procs =
to a
> 2 proc NT box. Anyone see a similar result? This is 805 on NT 4.0 =
SP5.
>=20
>=20
>=20 >=20 >=20
>=20> To REMOVE yourself from this mailing list, send an E-Mail message
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
 |
 |