| |
 |
|
Oracle Tips by Burleson Consulting
|
Adding Additional CPU
Processors
Most symmetric multiprocessor (SMP) architectures for Oracle
databases servers are expandable, and additional processors can be
added at any time. Once added, the processor architecture will
immediately make the new CPUs available to the Oracle database.
The problem with adding additional processors is the high cost that
can often outweigh the cost of a whole new server. Adding additional
processors to an existing server can commonly cost over $100,000,
and most managers require a detailed cost-benefit analysis when
making the decision to buy more CPUs. Essentially, the cost-benefit
analysis compares the lost productivity of the end users (due to the
response time latency) with the additional costs of the processors.
Another problem with justifying additional processors is the
sporadic nature of CPU overloads. Oracle database servers often
experience “transient” overloads, and there will be times when the
processors are heavily burdened and other times when the processors
are not at full utilization. Before recommending a processor
upgrade, most Oracle tuning professionals will perform a
load-balancing analysis to ensure that any batch-oriented tasks are
presented to the server at non-peak hours.
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
