Unfortunately,
accurate estimates of the CPU resources required for a certain level of activity
demands detailed insight into the amount of CPU power each transaction will
consume and how many transactions per minute or second the system will
184 | Chapter 7: Oracle Performance
process, both at peak and average workloads. Most organizations don??™t have the
time or resources for the system analysis and prototyping required to answer
these questions. This is perhaps why CPU shortages are so common, and why
the equally common solution is to simply add more CPUs to the machine until
the problem goes away. Real Application Clusters and the grid are attempts to at
least make adding more CPU horsepower easier.
Nondatabase workload
Not all organizations have the luxury of dedicating an entire machine to an Oracle
database to ensure that all CPU resources are available for that database. Use
operating system utilities to identify the top CPU consumers on the machine.
You may find that non-Oracle processes are consuming the bulk of the CPU
resources and adversely impacting database performance.
Pages:
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412