Books for you

182 | Chapter 7: Oracle Performance
Oracle and CPU Resources
The Oracle database shares the CPU(s) with all other software running on the server.
If there is a shortage of CPU power, reducing Oracle or non-Oracle CPU consumption
will improve the performance of all processes running on the server.
If all the CPUs in a machine are busy, the processes line up and wait for a turn to use
the CPU. This is called a run queue because processes are waiting to run on a CPU.
The busier the CPUs get, the longer processes can spend in this queue. A process in
the queue isn??™t doing any work, so as the run queue gets longer, response times
degrade.
You can use the standard monitoring tools for your particular operating
system to check the CPU utilization for that machine.
Tuning CPU usage is essentially an exercise in tuning individual tasks: it reduces the
number of commands required to accomplish the tasks and/or reduces the overall
number of tasks to be performed. You can do this tuning through workload balancing,
SQL tuning, or improved application design.


Pages:
383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407