In fact, computer environments are designed so that one resource
Performance Tuning Basics | 159
can try to compensate for the lack of another resource, sometimes leading to a deficit
in the compensating resource as well. If you run out of physical memory, the
operating system will swap areas of memory out to the disk and can cause I/O
bottlenecks.
You can identify your machine resource usage using Oracle Enterprise Manager and
tools provided by the machine vendor or operating system utilities. Since the introduction
of Enterprise Manager 10g, a performance analyzer called Automatic Performance
Monitoring (APM) has been included. APM gives you the ability to set up beacons,
which are client processes that periodically execute transactions and report the
response time. APM goes beyond the Oracle environment to help youu nderstand performance
from an end user??™s point of view, and this, in turn, can help you to spot
other sources of performance problems, such as network transmission slowdowns.
When All Else Fails
Your performance problems could be caused by your applications in situations
where performance tuning falls short in delivering desired results.
Pages:
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358