For more details, see the relevant Oracle guide for your development
language.
Oracle Database 10g and more recent versions include tuning tools that can easily spot
this type of potential application optimization.
Oracle Features for OLTP | 215
DBA to ensure that certain types of users receive sufficient machine resources to
meet performance requirements.
For example, you can allocate 80 percent of the CPU resources to order-entry users,
with the remaining 20 percent allocated to users asking for reports. This allocation
prevents reporting users from dominating the machine while order-entry users are
working. If the order-entry users aren??™t using all the allocated resources, the reporting
users can use more than their allotted percentage. If the order-entry workload
increases, the reporting users will be cut back to respect their 20 percent allocation. In
other words, the order-entry users will get up to 80 percent of CPU time, as needed,
while the users asking for reports will get at least 20 percent of the CPU time, and
more depending on how much the order-entry group is using.
Pages:
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475