(See the ???Database Advisors??? section in
Chapter 5 for more information on the various Oracle advisor tools.)
Machine Resource Usage
You can also run into performance issues if inadequate resources are available to the
database server. If your Oracle database is not properly deployed, adding machine
resources might help initially reduce performance bottlenecks, but can be an expensive
way to solve the problem. Further, the problem will likely resurface as additional
resources are consumed. But if your Oracle database is properly designed and configured
and you find such resource shortages, adding machine resources can be in order.
The performance of your Oracle database is based on how it uses the machine
resources that are available. These machine resources include processing power or
CPU, memory, disk I/O, and network bandwidth. Youcan trace the bulk of database
performance problems back to a bottleneck on one or more of these resources.
Network bandwidth between the server and a client is less of a problem today
because of the better bandwidth available in most locations.
Pages:
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356